Dataset statistics
| Number of variables | 53 |
|---|---|
| Number of observations | 83861 |
| Missing cells | 503168 |
| Missing cells (%) | 11.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 33.9 MiB |
| Average record size in memory | 424.0 B |
Variable types
| Numeric | 22 |
|---|---|
| Categorical | 25 |
| Unsupported | 6 |
customer_local_key has a high cardinality: 10580 distinct values | High cardinality |
branch_desc_cons has a high cardinality: 75 distinct values | High cardinality |
driver_name has a high cardinality: 27785 distinct values | High cardinality |
start_date_leasecontract has a high cardinality: 3782 distinct values | High cardinality |
end_date_leasecontract has a high cardinality: 3459 distinct values | High cardinality |
customer_driver_id has a high cardinality: 34378 distinct values | High cardinality |
vehicle_local_key has a high cardinality: 83861 distinct values | High cardinality |
registration_date has a high cardinality: 4215 distinct values | High cardinality |
model_cons has a high cardinality: 433 distinct values | High cardinality |
model_type_desc has a high cardinality: 8914 distinct values | High cardinality |
enriched_model has a high cardinality: 425 distinct values | High cardinality |
lease_contract_id is highly correlated with vehicle_id | High correlation |
vehicle_id is highly correlated with lease_contract_id | High correlation |
manufacturer_group is highly correlated with make_cons and 1 other fields | High correlation |
make_cons is highly correlated with manufacturer_group and 1 other fields | High correlation |
Customer_Segment is highly correlated with business_classification_desc | High correlation |
segment_global is highly correlated with vehicle_type_cons and 1 other fields | High correlation |
enriched_make is highly correlated with manufacturer_group and 1 other fields | High correlation |
vehicle_segment_desc is highly correlated with vehicle_type_cons | High correlation |
vehicle_type_cons is highly correlated with segment_global and 2 other fields | High correlation |
business_classification_desc is highly correlated with Customer_Segment | High correlation |
segment_regional is highly correlated with segment_global and 1 other fields | High correlation |
Unnamed: 47 has 83861 (100.0%) missing values | Missing |
Unnamed: 48 has 83861 (100.0%) missing values | Missing |
Unnamed: 49 has 83861 (100.0%) missing values | Missing |
Unnamed: 50 has 83861 (100.0%) missing values | Missing |
Unnamed: 51 has 83861 (100.0%) missing values | Missing |
Unnamed: 52 has 83861 (100.0%) missing values | Missing |
vehicle_local_key is uniformly distributed | Uniform |
lease_contract_id has unique values | Unique |
leasecontract_number has unique values | Unique |
vehicle_id has unique values | Unique |
vehicle_local_key has unique values | Unique |
Unnamed: 47 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 48 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 49 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 50 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 51 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 52 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
fuel_consump_manufacturer has 49765 (59.3%) zeros | Zeros |
cat_price_options_euro has 37607 (44.8%) zeros | Zeros |
cat_price_accessories_euro has 64618 (77.1%) zeros | Zeros |
gross_weight has 1980 (2.4%) zeros | Zeros |
tare_weight has 5642 (6.7%) zeros | Zeros |
co2_level_combined has 3992 (4.8%) zeros | Zeros |
number_of_cylinders has 3673 (4.4%) zeros | Zeros |
number_of_doors has 20982 (25.0%) zeros | Zeros |
supplier_discount_perc has 44032 (52.5%) zeros | Zeros |
discount_to_customer has 17539 (20.9%) zeros | Zeros |
Reproduction
| Analysis started | 2022-05-03 04:06:10.400870 |
|---|---|
| Analysis finished | 2022-05-03 04:07:41.427456 |
| Duration | 1 minute and 31.03 seconds |
| Software version | pandas-profiling v2.10.0 |
| Download configuration | config.yaml |
srno
Real number (ℝ≥0)
| Distinct | 6616 |
|---|---|
| Distinct (%) | 7.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1994.856429 |
|---|---|
| Minimum | 0 |
| Maximum | 6646 |
| Zeros | 40 |
| Zeros (%) | < 0.1% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 108 |
| Q1 | 593 |
| median | 1575 |
| Q3 | 3097 |
| 95-th percentile | 5306 |
| Maximum | 6646 |
| Range | 6646 |
| Interquartile range (IQR) | 2504 |
Descriptive statistics
| Standard deviation | 1646.718194 |
|---|---|
| Coefficient of variation (CV) | 0.82548206 |
| Kurtosis | -0.3773184143 |
| Mean | 1994.856429 |
| Median Absolute Deviation (MAD) | 1129 |
| Skewness | 0.7773796853 |
| Sum | 167290655 |
| Variance | 2711680.812 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 168 | 45 | 0.1% |
| 175 | 45 | 0.1% |
| 166 | 44 | 0.1% |
| 174 | 44 | 0.1% |
| 163 | 44 | 0.1% |
| 124 | 44 | 0.1% |
| 91 | 44 | 0.1% |
| 162 | 43 | 0.1% |
| 96 | 43 | 0.1% |
| 93 | 43 | 0.1% |
| Other values (6606) | 83422 |
| Value | Count | Frequency (%) |
| 0 | 40 | |
| 1 | 42 | |
| 2 | 41 | |
| 3 | 40 | |
| 4 | 37 |
| Value | Count | Frequency (%) |
| 6646 | 1 | |
| 6645 | 1 | |
| 6644 | 1 | |
| 6643 | 1 | |
| 6642 | 1 |
customer_number
Real number (ℝ≥0)
| Distinct | 10580 |
|---|---|
| Distinct (%) | 12.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 203629.6177 |
|---|---|
| Minimum | 25 |
| Maximum | 915070 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | 25 |
|---|---|
| 5-th percentile | 19943 |
| Q1 | 33373 |
| median | 36877 |
| Q3 | 340638 |
| 95-th percentile | 907054 |
| Maximum | 915070 |
| Range | 915045 |
| Interquartile range (IQR) | 307265 |
Descriptive statistics
| Standard deviation | 298788.1306 |
|---|---|
| Coefficient of variation (CV) | 1.467311749 |
| Kurtosis | 0.5970858869 |
| Mean | 203629.6177 |
| Median Absolute Deviation (MAD) | 11568 |
| Skewness | 1.488576852 |
| Sum | 1.707658337 × 1010 |
| Variance | 8.9274347 × 1010 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 33373 | 2914 | 3.5% |
| 33646 | 2589 | 3.1% |
| 28067 | 2240 | 2.7% |
| 20871 | 1897 | 2.3% |
| 91770 | 1674 | 2.0% |
| 33455 | 1640 | 2.0% |
| 907054 | 1335 | 1.6% |
| 36831 | 1279 | 1.5% |
| 43012 | 933 | 1.1% |
| 909427 | 925 | 1.1% |
| Other values (10570) | 66435 |
| Value | Count | Frequency (%) |
| 25 | 2 | < 0.1% |
| 1080 | 25 | |
| 4733 | 45 | |
| 5802 | 5 | < 0.1% |
| 5961 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 915070 | 8 | < 0.1% |
| 915035 | 31 | |
| 915032 | 6 | < 0.1% |
| 915021 | 3 | < 0.1% |
| 914100 | 8 | < 0.1% |
customer_id
Real number (ℝ≥0)
| Distinct | 10580 |
|---|---|
| Distinct (%) | 12.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25924485.95 |
|---|---|
| Minimum | 23485848 |
| Maximum | 41108039 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | 23485848 |
|---|---|
| 5-th percentile | 23490209 |
| Q1 | 23511969 |
| median | 23598677 |
| Q3 | 28387258 |
| 95-th percentile | 34975162 |
| Maximum | 41108039 |
| Range | 17622191 |
| Interquartile range (IQR) | 4875289 |
Descriptive statistics
| Standard deviation | 4104296.861 |
|---|---|
| Coefficient of variation (CV) | 0.1583173865 |
| Kurtosis | 1.744061272 |
| Mean | 25924485.95 |
| Median Absolute Deviation (MAD) | 97423 |
| Skewness | 1.657312443 |
| Sum | 2.174053316 × 1012 |
| Variance | 1.684525273 × 1013 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 23512100 | 2914 | 3.5% |
| 23511969 | 2589 | 3.1% |
| 23486802 | 2240 | 2.7% |
| 23492064 | 1897 | 2.3% |
| 23607324 | 1674 | 2.0% |
| 23512370 | 1640 | 2.0% |
| 23618292 | 1335 | 1.6% |
| 29458632 | 1279 | 1.5% |
| 23541849 | 933 | 1.1% |
| 23605624 | 925 | 1.1% |
| Other values (10570) | 66435 |
| Value | Count | Frequency (%) |
| 23485848 | 2 | |
| 23485863 | 2 | |
| 23485865 | 2 | |
| 23485893 | 3 | |
| 23485914 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 41108039 | 5 | < 0.1% |
| 41084355 | 5 | < 0.1% |
| 41037561 | 5 | < 0.1% |
| 40966199 | 2 | < 0.1% |
| 40913667 | 20 |
| Distinct | 10580 |
|---|---|
| Distinct (%) | 12.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| UK-C-33373 | 2914 |
|---|---|
| UK-C-33646 | 2589 |
| UK-C-28067 | 2240 |
| UK-C-20871 | 1897 |
| UK-C-91770 | 1674 |
| Other values (10575) |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 10.25371746 |
| Min length | 7 |
Characters and Unicode
| Total characters | 859887 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1506 ? |
|---|---|
| Unique (%) | 1.8% |
Sample
| 1st row | UK-C-506550 |
|---|---|
| 2nd row | UK-C-506550 |
| 3rd row | UK-C-841984 |
| 4th row | UK-C-841984 |
| 5th row | UK-C-850742 |
| Value | Count | Frequency (%) |
| UK-C-33373 | 2914 | 3.5% |
| UK-C-33646 | 2589 | 3.1% |
| UK-C-28067 | 2240 | 2.7% |
| UK-C-20871 | 1897 | 2.3% |
| UK-C-91770 | 1674 | 2.0% |
| UK-C-33455 | 1640 | 2.0% |
| UK-C-907054 | 1335 | 1.6% |
| UK-C-36831 | 1279 | 1.5% |
| UK-C-43012 | 933 | 1.1% |
| UK-C-909427 | 925 | 1.1% |
| Other values (10570) | 66435 |
| Value | Count | Frequency (%) |
| uk-c-33373 | 2914 | 3.5% |
| uk-c-33646 | 2589 | 3.1% |
| uk-c-28067 | 2240 | 2.7% |
| uk-c-20871 | 1897 | 2.3% |
| uk-c-91770 | 1674 | 2.0% |
| uk-c-33455 | 1640 | 2.0% |
| uk-c-907054 | 1335 | 1.6% |
| uk-c-36831 | 1279 | 1.5% |
| uk-c-43012 | 933 | 1.1% |
| uk-c-909427 | 925 | 1.1% |
| Other values (10570) | 66435 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 167722 | |
| U | 83861 | |
| K | 83861 | |
| C | 83861 | |
| 3 | 79403 | |
| 4 | 49503 | 5.8% |
| 7 | 43518 | 5.1% |
| 0 | 42574 | 5.0% |
| 2 | 39537 | 4.6% |
| 9 | 38288 | 4.5% |
| Other values (4) | 147759 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 440582 | |
| Uppercase Letter | 251583 | |
| Dash Punctuation | 167722 | 19.5% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 3 | 79403 | |
| 4 | 49503 | |
| 7 | 43518 | |
| 0 | 42574 | |
| 2 | 39537 | |
| 9 | 38288 | |
| 1 | 38174 | |
| 6 | 37823 | |
| 8 | 36680 | |
| 5 | 35082 |
| Value | Count | Frequency (%) |
| U | 83861 | |
| K | 83861 | |
| C | 83861 |
| Value | Count | Frequency (%) |
| - | 167722 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 608304 | |
| Latin | 251583 |
Most frequent character per script
| Value | Count | Frequency (%) |
| - | 167722 | |
| 3 | 79403 | |
| 4 | 49503 | 8.1% |
| 7 | 43518 | 7.2% |
| 0 | 42574 | 7.0% |
| 2 | 39537 | 6.5% |
| 9 | 38288 | 6.3% |
| 1 | 38174 | 6.3% |
| 6 | 37823 | 6.2% |
| 8 | 36680 | 6.0% |
| Value | Count | Frequency (%) |
| U | 83861 | |
| K | 83861 | |
| C | 83861 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 859887 |
Most frequent character per block
| Value | Count | Frequency (%) |
| - | 167722 | |
| U | 83861 | |
| K | 83861 | |
| C | 83861 | |
| 3 | 79403 | |
| 4 | 49503 | 5.8% |
| 7 | 43518 | 5.1% |
| 0 | 42574 | 5.0% |
| 2 | 39537 | 4.6% |
| 9 | 38288 | 4.5% |
| Other values (4) | 147759 |
| Distinct | 75 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| Business Services | |
|---|---|
| Not consolidated | |
| Private Households | |
| Wholesale Trade--Durable Goods | |
| Electric, Gas, And Sanitary Services (Private Companies) | 4004 |
| Other values (70) |
Length
| Max length | 59 |
|---|---|
| Median length | 18 |
| Mean length | 24.65413005 |
| Min length | 7 |
Characters and Unicode
| Total characters | 2067520 |
|---|---|
| Distinct characters | 51 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Furniture And Fixtures |
|---|---|
| 2nd row | Furniture And Fixtures |
| 3rd row | Private Households |
| 4th row | Private Households |
| 5th row | Special Trade Contractors |
| Value | Count | Frequency (%) |
| Business Services | 14307 | |
| Not consolidated | 7222 | 8.6% |
| Private Households | 6729 | 8.0% |
| Wholesale Trade--Durable Goods | 4923 | 5.9% |
| Electric, Gas, And Sanitary Services (Private Companies) | 4004 | 4.8% |
| Insurance Carriers | 3627 | 4.3% |
| Real Estate | 3257 | 3.9% |
| Special Trade Contractors | 2936 | 3.5% |
| Health Services | 2869 | 3.4% |
| Wholesale Trade--Nondurable Goods | 2779 | 3.3% |
| Other values (65) | 31208 |
| Value | Count | Frequency (%) |
| services | 26139 | 10.6% |
| and | 14997 | 6.1% |
| business | 14307 | 5.8% |
| private | 10733 | 4.3% |
| goods | 8994 | 3.6% |
| 7754 | 3.1% | |
| wholesale | 7702 | 3.1% |
| not | 7222 | 2.9% |
| consolidated | 7222 | 2.9% |
| households | 6729 | 2.7% |
| Other values (143) | 135462 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 211999 | 10.3% |
| s | 167652 | 8.1% |
| 163400 | 7.9% | |
| r | 139345 | 6.7% |
| i | 134949 | 6.5% |
| a | 132382 | 6.4% |
| o | 129958 | 6.3% |
| t | 107933 | 5.2% |
| n | 106715 | 5.2% |
| c | 97675 | 4.7% |
| Other values (41) | 675512 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1617753 | |
| Uppercase Letter | 239955 | 11.6% |
| Space Separator | 163400 | 7.9% |
| Other Punctuation | 23000 | 1.1% |
| Dash Punctuation | 15404 | 0.7% |
| Open Punctuation | 4004 | 0.2% |
| Close Punctuation | 4004 | 0.2% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 211999 | |
| s | 167652 | |
| r | 139345 | |
| i | 134949 | |
| a | 132382 | |
| o | 129958 | |
| t | 107933 | 6.7% |
| n | 106715 | 6.6% |
| c | 97675 | 6.0% |
| l | 89958 | 5.6% |
| Other values (14) | 299187 |
| Value | Count | Frequency (%) |
| S | 38116 | |
| C | 29382 | |
| P | 23645 | |
| A | 20044 | |
| E | 17006 | 7.1% |
| B | 15727 | 6.6% |
| G | 14819 | 6.2% |
| T | 13474 | 5.6% |
| H | 12613 | 5.3% |
| N | 10088 | 4.2% |
| Other values (10) | 45041 |
| Value | Count | Frequency (%) |
| , | 14837 | |
| & | 7754 | |
| . | 409 | 1.8% |
| Value | Count | Frequency (%) |
| 163400 |
| Value | Count | Frequency (%) |
| - | 15404 |
| Value | Count | Frequency (%) |
| ( | 4004 |
| Value | Count | Frequency (%) |
| ) | 4004 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1857708 | |
| Common | 209812 | 10.1% |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 211999 | 11.4% |
| s | 167652 | 9.0% |
| r | 139345 | 7.5% |
| i | 134949 | 7.3% |
| a | 132382 | 7.1% |
| o | 129958 | 7.0% |
| t | 107933 | 5.8% |
| n | 106715 | 5.7% |
| c | 97675 | 5.3% |
| l | 89958 | 4.8% |
| Other values (34) | 539142 |
| Value | Count | Frequency (%) |
| 163400 | ||
| - | 15404 | 7.3% |
| , | 14837 | 7.1% |
| & | 7754 | 3.7% |
| ( | 4004 | 1.9% |
| ) | 4004 | 1.9% |
| . | 409 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2067520 |
Most frequent character per block
| Value | Count | Frequency (%) |
| e | 211999 | 10.3% |
| s | 167652 | 8.1% |
| 163400 | 7.9% | |
| r | 139345 | 6.7% |
| i | 134949 | 6.5% |
| a | 132382 | 6.4% |
| o | 129958 | 6.3% |
| t | 107933 | 5.2% |
| n | 106715 | 5.2% |
| c | 97675 | 4.7% |
| Other values (41) | 675512 |
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| Corporate | |
|---|---|
| Small fleet | |
| Governments | |
| Private Households | |
| Insurance companies | 3608 |
| Other values (2) | 90 |
Length
| Max length | 19 |
|---|---|
| Median length | 9 |
| Mean length | 10.80540418 |
| Min length | 5 |
Characters and Unicode
| Total characters | 906152 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Small fleet |
|---|---|
| 2nd row | Small fleet |
| 3rd row | Private Households |
| 4th row | Private Households |
| 5th row | Small fleet |
| Value | Count | Frequency (%) |
| Corporate | 45877 | |
| Small fleet | 20402 | |
| Governments | 7155 | 8.5% |
| Private Households | 6729 | 8.0% |
| Insurance companies | 3608 | 4.3% |
| Banks | 88 | 0.1% |
| Own fleet | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| corporate | 45877 | |
| fleet | 20404 | |
| small | 20402 | |
| governments | 7155 | 6.2% |
| private | 6729 | 5.9% |
| households | 6729 | 5.9% |
| insurance | 3608 | 3.1% |
| companies | 3608 | 3.1% |
| banks | 88 | 0.1% |
| own | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 121669 | |
| o | 115975 | |
| r | 109246 | |
| a | 80312 | |
| t | 80165 | |
| l | 67937 | 7.5% |
| p | 49485 | 5.5% |
| C | 45877 | 5.1% |
| m | 31165 | 3.4% |
| 30741 | 3.4% | |
| Other values (18) | 173580 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 784821 | |
| Uppercase Letter | 90590 | 10.0% |
| Space Separator | 30741 | 3.4% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 121669 | |
| o | 115975 | |
| r | 109246 | |
| a | 80312 | |
| t | 80165 | |
| l | 67937 | |
| p | 49485 | |
| m | 31165 | 4.0% |
| s | 27917 | 3.6% |
| n | 25224 | 3.2% |
| Other values (9) | 75726 |
| Value | Count | Frequency (%) |
| C | 45877 | |
| S | 20402 | |
| G | 7155 | 7.9% |
| P | 6729 | 7.4% |
| H | 6729 | 7.4% |
| I | 3608 | 4.0% |
| B | 88 | 0.1% |
| O | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 30741 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 875411 | |
| Common | 30741 | 3.4% |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 121669 | |
| o | 115975 | |
| r | 109246 | |
| a | 80312 | |
| t | 80165 | |
| l | 67937 | |
| p | 49485 | 5.7% |
| C | 45877 | 5.2% |
| m | 31165 | 3.6% |
| s | 27917 | 3.2% |
| Other values (17) | 145663 |
| Value | Count | Frequency (%) |
| 30741 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 906152 |
Most frequent character per block
| Value | Count | Frequency (%) |
| e | 121669 | |
| o | 115975 | |
| r | 109246 | |
| a | 80312 | |
| t | 80165 | |
| l | 67937 | 7.5% |
| p | 49485 | 5.5% |
| C | 45877 | 5.1% |
| m | 31165 | 3.4% |
| 30741 | 3.4% | |
| Other values (18) | 173580 |
| Distinct | 27785 |
|---|---|
| Distinct (%) | 33.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| Network Driver | |
|---|---|
| POOL | 711 |
| CARPOOL | 705 |
| TBC TBC | 616 |
| UNSPECIFIED | 549 |
| Other values (27780) |
Length
| Max length | 36 |
|---|---|
| Median length | 13 |
| Mean length | 13.52125541 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1133906 |
|---|---|
| Distinct characters | 76 |
| Distinct categories | 10 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 4443 ? |
|---|---|
| Unique (%) | 5.3% |
Sample
| 1st row | toby downes |
|---|---|
| 2nd row | toby downes |
| 3rd row | thomas fosmes |
| 4th row | thomas fosmes |
| 5th row | terry cottam |
| Value | Count | Frequency (%) |
| Network Driver | 8385 | 10.0% |
| POOL | 711 | 0.8% |
| CARPOOL | 705 | 0.8% |
| TBC TBC | 616 | 0.7% |
| UNSPECIFIED | 549 | 0.7% |
| TBA TBA | 428 | 0.5% |
| POOL CAR | 401 | 0.5% |
| POOL POOL | 368 | 0.4% |
| POOL VEHICLE | 340 | 0.4% |
| POOL VAN | 326 | 0.4% |
| Other values (27775) | 71032 |
| Value | Count | Frequency (%) |
| pool | 10481 | 5.8% |
| driver | 8688 | 4.8% |
| network | 8446 | 4.7% |
| auction | 3101 | 1.7% |
| return | 2316 | 1.3% |
| paul | 1815 | 1.0% |
| david | 1791 | 1.0% |
| c/o | 1724 | 1.0% |
| mark | 1492 | 0.8% |
| andrew | 1472 | 0.8% |
| Other values (15826) | 137954 |
Most occurring characters
| Value | Count | Frequency (%) |
| 95458 | 8.4% | |
| A | 74578 | 6.6% |
| E | 72897 | 6.4% |
| O | 71914 | 6.3% |
| N | 68249 | 6.0% |
| R | 63381 | 5.6% |
| L | 56353 | 5.0% |
| I | 48106 | 4.2% |
| T | 45222 | 4.0% |
| S | 38489 | 3.4% |
| Other values (66) | 499259 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 812775 | |
| Lowercase Letter | 164942 | 14.5% |
| Space Separator | 95458 | 8.4% |
| Decimal Number | 55642 | 4.9% |
| Other Punctuation | 3779 | 0.3% |
| Dash Punctuation | 1066 | 0.1% |
| Connector Punctuation | 88 | < 0.1% |
| Open Punctuation | 77 | < 0.1% |
| Close Punctuation | 76 | < 0.1% |
| Math Symbol | 3 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| r | 31614 | |
| e | 25227 | |
| i | 13979 | |
| o | 13428 | |
| t | 12404 | 7.5% |
| k | 9461 | 5.7% |
| w | 9399 | 5.7% |
| v | 9163 | 5.6% |
| a | 8842 | 5.4% |
| n | 6533 | 4.0% |
| Other values (16) | 24892 |
| Value | Count | Frequency (%) |
| A | 74578 | 9.2% |
| E | 72897 | 9.0% |
| O | 71914 | 8.8% |
| N | 68249 | 8.4% |
| R | 63381 | 7.8% |
| L | 56353 | 6.9% |
| I | 48106 | 5.9% |
| T | 45222 | 5.6% |
| S | 38489 | 4.7% |
| C | 38235 | 4.7% |
| Other values (16) | 235351 |
| Value | Count | Frequency (%) |
| 1 | 12460 | |
| 0 | 11346 | |
| 3 | 5588 | |
| 2 | 5126 | |
| 4 | 4733 | 8.5% |
| 5 | 3829 | 6.9% |
| 7 | 3602 | 6.5% |
| 8 | 3366 | 6.0% |
| 6 | 3331 | 6.0% |
| 9 | 2261 | 4.1% |
| Value | Count | Frequency (%) |
| / | 2359 | |
| . | 927 | 24.5% |
| ' | 306 | 8.1% |
| & | 83 | 2.2% |
| : | 54 | 1.4% |
| * | 31 | 0.8% |
| # | 10 | 0.3% |
| , | 9 | 0.2% |
| Value | Count | Frequency (%) |
| 95458 |
| Value | Count | Frequency (%) |
| - | 1066 |
| Value | Count | Frequency (%) |
| _ | 88 |
| Value | Count | Frequency (%) |
| ( | 77 |
| Value | Count | Frequency (%) |
| ) | 76 |
| Value | Count | Frequency (%) |
| + | 3 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 977717 | |
| Common | 156189 | 13.8% |
Most frequent character per script
| Value | Count | Frequency (%) |
| A | 74578 | 7.6% |
| E | 72897 | 7.5% |
| O | 71914 | 7.4% |
| N | 68249 | 7.0% |
| R | 63381 | 6.5% |
| L | 56353 | 5.8% |
| I | 48106 | 4.9% |
| T | 45222 | 4.6% |
| S | 38489 | 3.9% |
| C | 38235 | 3.9% |
| Other values (42) | 400293 |
| Value | Count | Frequency (%) |
| 95458 | ||
| 1 | 12460 | 8.0% |
| 0 | 11346 | 7.3% |
| 3 | 5588 | 3.6% |
| 2 | 5126 | 3.3% |
| 4 | 4733 | 3.0% |
| 5 | 3829 | 2.5% |
| 7 | 3602 | 2.3% |
| 8 | 3366 | 2.2% |
| 6 | 3331 | 2.1% |
| Other values (14) | 7350 | 4.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1133906 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 95458 | 8.4% | |
| A | 74578 | 6.6% |
| E | 72897 | 6.4% |
| O | 71914 | 6.3% |
| N | 68249 | 6.0% |
| R | 63381 | 5.6% |
| L | 56353 | 5.0% |
| I | 48106 | 4.2% |
| T | 45222 | 4.0% |
| S | 38489 | 3.4% |
| Other values (66) | 499259 |
| Distinct | 3782 |
|---|---|
| Distinct (%) | 4.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| 2012-12-01 00:00:00 | 272 |
|---|---|
| 2014-06-01 00:00:00 | 239 |
| 2013-07-01 00:00:00 | 215 |
| 2015-06-01 00:00:00 | 188 |
| 2020-04-01 00:00:00 | 176 |
| Other values (3777) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 1593359 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 169 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | 2014-03-10 00:00:00 |
|---|---|
| 2nd row | 2018-04-10 00:00:00 |
| 3rd row | 2016-04-25 00:00:00 |
| 4th row | 2018-05-25 00:00:00 |
| 5th row | 2016-09-26 00:00:00 |
| Value | Count | Frequency (%) |
| 2012-12-01 00:00:00 | 272 | 0.3% |
| 2014-06-01 00:00:00 | 239 | 0.3% |
| 2013-07-01 00:00:00 | 215 | 0.3% |
| 2015-06-01 00:00:00 | 188 | 0.2% |
| 2020-04-01 00:00:00 | 176 | 0.2% |
| 2012-11-01 00:00:00 | 165 | 0.2% |
| 2012-06-01 00:00:00 | 156 | 0.2% |
| 2013-03-01 00:00:00 | 154 | 0.2% |
| 2013-06-01 00:00:00 | 140 | 0.2% |
| 2017-03-01 00:00:00 | 127 | 0.2% |
| Other values (3772) | 82029 |
| Value | Count | Frequency (%) |
| 00:00:00 | 83861 | |
| 2012-12-01 | 272 | 0.2% |
| 2014-06-01 | 239 | 0.1% |
| 2013-07-01 | 215 | 0.1% |
| 2015-06-01 | 188 | 0.1% |
| 2020-04-01 | 176 | 0.1% |
| 2012-11-01 | 165 | 0.1% |
| 2012-06-01 | 156 | 0.1% |
| 2013-03-01 | 154 | 0.1% |
| 2013-06-01 | 140 | 0.1% |
| Other values (3773) | 82156 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 703459 | |
| - | 167722 | 10.5% |
| : | 167722 | 10.5% |
| 1 | 160500 | 10.1% |
| 2 | 141907 | 8.9% |
| 83861 | 5.3% | |
| 3 | 29649 | 1.9% |
| 6 | 25871 | 1.6% |
| 5 | 25282 | 1.6% |
| 4 | 22795 | 1.4% |
| Other values (3) | 64591 | 4.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1174054 | |
| Dash Punctuation | 167722 | 10.5% |
| Other Punctuation | 167722 | 10.5% |
| Space Separator | 83861 | 5.3% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 703459 | |
| 1 | 160500 | 13.7% |
| 2 | 141907 | 12.1% |
| 3 | 29649 | 2.5% |
| 6 | 25871 | 2.2% |
| 5 | 25282 | 2.2% |
| 4 | 22795 | 1.9% |
| 7 | 22733 | 1.9% |
| 9 | 21617 | 1.8% |
| 8 | 20241 | 1.7% |
| Value | Count | Frequency (%) |
| - | 167722 |
| Value | Count | Frequency (%) |
| 83861 |
| Value | Count | Frequency (%) |
| : | 167722 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1593359 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 703459 | |
| - | 167722 | 10.5% |
| : | 167722 | 10.5% |
| 1 | 160500 | 10.1% |
| 2 | 141907 | 8.9% |
| 83861 | 5.3% | |
| 3 | 29649 | 1.9% |
| 6 | 25871 | 1.6% |
| 5 | 25282 | 1.6% |
| 4 | 22795 | 1.4% |
| Other values (3) | 64591 | 4.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1593359 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 703459 | |
| - | 167722 | 10.5% |
| : | 167722 | 10.5% |
| 1 | 160500 | 10.1% |
| 2 | 141907 | 8.9% |
| 83861 | 5.3% | |
| 3 | 29649 | 1.9% |
| 6 | 25871 | 1.6% |
| 5 | 25282 | 1.6% |
| 4 | 22795 | 1.4% |
| Other values (3) | 64591 | 4.1% |
| Distinct | 3459 |
|---|---|
| Distinct (%) | 4.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| ############################################################################################################################################################################################################################################################### | |
|---|---|
| 2020-04-30 00:00:00 | 398 |
| 2020-03-31 00:00:00 | 344 |
| 2013-06-30 00:00:00 | 191 |
| 2015-05-31 00:00:00 | 171 |
| Other values (3454) |
Length
| Max length | 255 |
|---|---|
| Median length | 19 |
| Mean length | 81.08082422 |
| Min length | 19 |
Characters and Unicode
| Total characters | 6799519 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 212 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | 2018-04-09 00:00:00 |
|---|---|
| 2nd row | 2019-04-08 00:00:00 |
| 3rd row | 2018-05-24 00:00:00 |
| 4th row | 2018-10-08 00:00:00 |
| 5th row | 2019-09-25 00:00:00 |
| Value | Count | Frequency (%) |
| ############################################################################################################################################################################################################################################################### | 22060 | 26.3% |
| 2020-04-30 00:00:00 | 398 | 0.5% |
| 2020-03-31 00:00:00 | 344 | 0.4% |
| 2013-06-30 00:00:00 | 191 | 0.2% |
| 2015-05-31 00:00:00 | 171 | 0.2% |
| 2013-05-31 00:00:00 | 108 | 0.1% |
| 2014-05-31 00:00:00 | 102 | 0.1% |
| 2017-02-28 00:00:00 | 101 | 0.1% |
| 2013-11-14 00:00:00 | 89 | 0.1% |
| 2016-09-30 00:00:00 | 86 | 0.1% |
| Other values (3449) | 60211 |
| Value | Count | Frequency (%) |
| 00:00:00 | 61801 | |
| 22060 | 15.1% | |
| 2020-04-30 | 398 | 0.3% |
| 2020-03-31 | 344 | 0.2% |
| 2013-06-30 | 191 | 0.1% |
| 2015-05-31 | 171 | 0.1% |
| 2013-05-31 | 108 | 0.1% |
| 2014-05-31 | 102 | 0.1% |
| 2017-02-28 | 101 | 0.1% |
| 2013-11-14 | 89 | 0.1% |
| Other values (3450) | 60297 |
Most occurring characters
| Value | Count | Frequency (%) |
| # | 5625300 | |
| 0 | 516118 | 7.6% |
| - | 123602 | 1.8% |
| : | 123602 | 1.8% |
| 1 | 109701 | 1.6% |
| 2 | 103127 | 1.5% |
| 61801 | 0.9% | |
| 3 | 21343 | 0.3% |
| 9 | 20321 | 0.3% |
| 6 | 19778 | 0.3% |
| Other values (4) | 74826 | 1.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Other Punctuation | 5748902 | |
| Decimal Number | 865214 | 12.7% |
| Dash Punctuation | 123602 | 1.8% |
| Space Separator | 61801 | 0.9% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 516118 | |
| 1 | 109701 | 12.7% |
| 2 | 103127 | 11.9% |
| 3 | 21343 | 2.5% |
| 9 | 20321 | 2.3% |
| 6 | 19778 | 2.3% |
| 7 | 18996 | 2.2% |
| 5 | 18943 | 2.2% |
| 4 | 18446 | 2.1% |
| 8 | 18441 | 2.1% |
| Value | Count | Frequency (%) |
| # | 5625300 | |
| : | 123602 | 2.2% |
| Value | Count | Frequency (%) |
| - | 123602 |
| Value | Count | Frequency (%) |
| 61801 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 6799519 |
Most frequent character per script
| Value | Count | Frequency (%) |
| # | 5625300 | |
| 0 | 516118 | 7.6% |
| - | 123602 | 1.8% |
| : | 123602 | 1.8% |
| 1 | 109701 | 1.6% |
| 2 | 103127 | 1.5% |
| 61801 | 0.9% | |
| 3 | 21343 | 0.3% |
| 9 | 20321 | 0.3% |
| 6 | 19778 | 0.3% |
| Other values (4) | 74826 | 1.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6799519 |
Most frequent character per block
| Value | Count | Frequency (%) |
| # | 5625300 | |
| 0 | 516118 | 7.6% |
| - | 123602 | 1.8% |
| : | 123602 | 1.8% |
| 1 | 109701 | 1.6% |
| 2 | 103127 | 1.5% |
| 61801 | 0.9% | |
| 3 | 21343 | 0.3% |
| 9 | 20321 | 0.3% |
| 6 | 19778 | 0.3% |
| Other values (4) | 74826 | 1.1% |
leasecontract_status_cons
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| Ended | |
|---|---|
| Operational | |
| On order | 3 |
Length
| Max length | 11 |
|---|---|
| Median length | 5 |
| Mean length | 6.578218719 |
| Min length | 5 |
Characters and Unicode
| Total characters | 551656 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Ended |
|---|---|
| 2nd row | Ended |
| 3rd row | Ended |
| 4th row | Ended |
| 5th row | Ended |
| Value | Count | Frequency (%) |
| Ended | 61801 | |
| Operational | 22057 | 26.3% |
| On order | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| ended | 61801 | |
| operational | 22057 | 26.3% |
| on | 3 | < 0.1% |
| order | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| d | 123605 | |
| n | 83861 | |
| e | 83861 | |
| E | 61801 | |
| a | 44114 | 8.0% |
| r | 22063 | 4.0% |
| O | 22060 | 4.0% |
| o | 22060 | 4.0% |
| p | 22057 | 4.0% |
| t | 22057 | 4.0% |
| Other values (3) | 44117 | 8.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 467792 | |
| Uppercase Letter | 83861 | 15.2% |
| Space Separator | 3 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| d | 123605 | |
| n | 83861 | |
| e | 83861 | |
| a | 44114 | 9.4% |
| r | 22063 | 4.7% |
| o | 22060 | 4.7% |
| p | 22057 | 4.7% |
| t | 22057 | 4.7% |
| i | 22057 | 4.7% |
| l | 22057 | 4.7% |
| Value | Count | Frequency (%) |
| E | 61801 | |
| O | 22060 | 26.3% |
| Value | Count | Frequency (%) |
| 3 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 551653 | |
| Common | 3 | < 0.1% |
Most frequent character per script
| Value | Count | Frequency (%) |
| d | 123605 | |
| n | 83861 | |
| e | 83861 | |
| E | 61801 | |
| a | 44114 | 8.0% |
| r | 22063 | 4.0% |
| O | 22060 | 4.0% |
| o | 22060 | 4.0% |
| p | 22057 | 4.0% |
| t | 22057 | 4.0% |
| Other values (2) | 44114 | 8.0% |
| Value | Count | Frequency (%) |
| 3 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 551656 |
Most frequent character per block
| Value | Count | Frequency (%) |
| d | 123605 | |
| n | 83861 | |
| e | 83861 | |
| E | 61801 | |
| a | 44114 | 8.0% |
| r | 22063 | 4.0% |
| O | 22060 | 4.0% |
| o | 22060 | 4.0% |
| p | 22057 | 4.0% |
| t | 22057 | 4.0% |
| Other values (3) | 44117 | 8.0% |
| Distinct | 34378 |
|---|---|
| Distinct (%) | 41.0% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 655.3 KiB |
| UNSPEC | 637 |
|---|---|
| Pool | 543 |
| POOL | 504 |
| CARPOOL | 405 |
| POOL1 | 391 |
| Other values (34373) |
Length
| Max length | 20 |
|---|---|
| Median length | 8 |
| Mean length | 10.31539847 |
| Min length | 1 |
Characters and Unicode
| Total characters | 865039 |
|---|---|
| Distinct characters | 80 |
| Distinct categories | 10 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 6242 ? |
|---|---|
| Unique (%) | 7.4% |
Sample
| 1st row | 00000000000004999185 |
|---|---|
| 2nd row | 00000000000004999185 |
| 3rd row | 00000000000005174754 |
| 4th row | 00000000000005174754 |
| 5th row | 00000000000005210435 |
| Value | Count | Frequency (%) |
| UNSPEC | 637 | 0.8% |
| Pool | 543 | 0.6% |
| POOL | 504 | 0.6% |
| CARPOOL | 405 | 0.5% |
| POOL1 | 391 | 0.5% |
| POOLVAN | 235 | 0.3% |
| AUCTIONRETURN | 190 | 0.2% |
| pool | 189 | 0.2% |
| 1 | 188 | 0.2% |
| AUCTION RETURN | 155 | 0.2% |
| Other values (34368) | 80422 |
| Value | Count | Frequency (%) |
| pool | 3120 | 3.3% |
| unspec | 781 | 0.8% |
| return | 690 | 0.7% |
| auction | 644 | 0.7% |
| carpool | 595 | 0.6% |
| pool1 | 472 | 0.5% |
| smh | 452 | 0.5% |
| 1 | 427 | 0.5% |
| poolvan | 298 | 0.3% |
| car | 243 | 0.3% |
| Other values (33932) | 85527 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 276015 | |
| 1 | 45988 | 5.3% |
| 5 | 36255 | 4.2% |
| 4 | 33138 | 3.8% |
| 2 | 32135 | 3.7% |
| 7 | 30404 | 3.5% |
| 3 | 29758 | 3.4% |
| 6 | 27424 | 3.2% |
| 8 | 26917 | 3.1% |
| 9 | 26815 | 3.1% |
| Other values (70) | 300190 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 564849 | |
| Uppercase Letter | 235438 | |
| Lowercase Letter | 53030 | 6.1% |
| Space Separator | 9395 | 1.1% |
| Other Punctuation | 1717 | 0.2% |
| Dash Punctuation | 591 | 0.1% |
| Close Punctuation | 8 | < 0.1% |
| Math Symbol | 5 | < 0.1% |
| Open Punctuation | 4 | < 0.1% |
| Currency Symbol | 2 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| O | 24646 | 10.5% |
| A | 17846 | 7.6% |
| R | 16858 | 7.2% |
| E | 16364 | 7.0% |
| L | 16358 | 6.9% |
| C | 16153 | 6.9% |
| N | 15827 | 6.7% |
| T | 13912 | 5.9% |
| P | 13879 | 5.9% |
| S | 11355 | 4.8% |
| Other values (17) | 72240 |
| Value | Count | Frequency (%) |
| o | 8132 | |
| e | 5503 | |
| l | 5290 | |
| a | 4439 | 8.4% |
| r | 4273 | 8.1% |
| n | 3828 | 7.2% |
| i | 3028 | 5.7% |
| t | 2771 | 5.2% |
| s | 2717 | 5.1% |
| c | 1724 | 3.3% |
| Other values (16) | 11325 |
| Value | Count | Frequency (%) |
| 0 | 276015 | |
| 1 | 45988 | 8.1% |
| 5 | 36255 | 6.4% |
| 4 | 33138 | 5.9% |
| 2 | 32135 | 5.7% |
| 7 | 30404 | 5.4% |
| 3 | 29758 | 5.3% |
| 6 | 27424 | 4.9% |
| 8 | 26917 | 4.8% |
| 9 | 26815 | 4.7% |
| Value | Count | Frequency (%) |
| / | 1061 | |
| . | 341 | 19.9% |
| * | 116 | 6.8% |
| ! | 69 | 4.0% |
| , | 38 | 2.2% |
| ' | 38 | 2.2% |
| & | 25 | 1.5% |
| # | 19 | 1.1% |
| ; | 8 | 0.5% |
| ? | 2 | 0.1% |
| Value | Count | Frequency (%) |
| ) | 4 | |
| ] | 4 |
| Value | Count | Frequency (%) |
| 9395 |
| Value | Count | Frequency (%) |
| - | 591 |
| Value | Count | Frequency (%) |
| + | 5 |
| Value | Count | Frequency (%) |
| ( | 4 |
| Value | Count | Frequency (%) |
| £ | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 576571 | |
| Latin | 288468 |
Most frequent character per script
| Value | Count | Frequency (%) |
| O | 24646 | 8.5% |
| A | 17846 | 6.2% |
| R | 16858 | 5.8% |
| E | 16364 | 5.7% |
| L | 16358 | 5.7% |
| C | 16153 | 5.6% |
| N | 15827 | 5.5% |
| T | 13912 | 4.8% |
| P | 13879 | 4.8% |
| S | 11355 | 3.9% |
| Other values (43) | 125270 |
| Value | Count | Frequency (%) |
| 0 | 276015 | |
| 1 | 45988 | 8.0% |
| 5 | 36255 | 6.3% |
| 4 | 33138 | 5.7% |
| 2 | 32135 | 5.6% |
| 7 | 30404 | 5.3% |
| 3 | 29758 | 5.2% |
| 6 | 27424 | 4.8% |
| 8 | 26917 | 4.7% |
| 9 | 26815 | 4.7% |
| Other values (17) | 11722 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 865035 | |
| None | 4 | < 0.1% |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 276015 | |
| 1 | 45988 | 5.3% |
| 5 | 36255 | 4.2% |
| 4 | 33138 | 3.8% |
| 2 | 32135 | 3.7% |
| 7 | 30404 | 3.5% |
| 3 | 29758 | 3.4% |
| 6 | 27424 | 3.2% |
| 8 | 26917 | 3.1% |
| 9 | 26815 | 3.1% |
| Other values (68) | 300186 |
| Value | Count | Frequency (%) |
| Â | 2 | |
| £ | 2 |
| Distinct | 83861 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 226362286.2 |
|---|---|
| Minimum | 133487525 |
| Maximum | 393841442 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | 133487525 |
|---|---|
| 5-th percentile | 133559809 |
| Q1 | 145944277 |
| median | 180316621 |
| Q3 | 305582607 |
| 95-th percentile | 371542115 |
| Maximum | 393841442 |
| Range | 260353917 |
| Interquartile range (IQR) | 159638330 |
Descriptive statistics
| Standard deviation | 86153066.95 |
|---|---|
| Coefficient of variation (CV) | 0.3805981483 |
| Kurtosis | -1.302507862 |
| Mean | 226362286.2 |
| Median Absolute Deviation (MAD) | 46769751 |
| Skewness | 0.4306453486 |
| Sum | 1.898296768 × 1013 |
| Variance | 7.422350944 × 1015 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 347736063 | 1 | < 0.1% |
| 242319973 | 1 | < 0.1% |
| 159171149 | 1 | < 0.1% |
| 133721209 | 1 | < 0.1% |
| 147335760 | 1 | < 0.1% |
| 133702225 | 1 | < 0.1% |
| 362914420 | 1 | < 0.1% |
| 133575251 | 1 | < 0.1% |
| 133696084 | 1 | < 0.1% |
| 159122005 | 1 | < 0.1% |
| Other values (83851) | 83851 |
| Value | Count | Frequency (%) |
| 133487525 | 1 | |
| 133505137 | 1 | |
| 133521619 | 1 | |
| 133522135 | 1 | |
| 133522311 | 1 |
| Value | Count | Frequency (%) |
| 393841442 | 1 | |
| 393841428 | 1 | |
| 393841420 | 1 | |
| 393841414 | 1 | |
| 393841390 | 1 |
| Distinct | 83861 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6021723.414 |
|---|---|
| Minimum | 1000011 |
| Maximum | 9999489 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | 1000011 |
|---|---|
| 5-th percentile | 1036110 |
| Q1 | 1181196 |
| median | 8868962 |
| Q3 | 9825950 |
| 95-th percentile | 9960990 |
| Maximum | 9999489 |
| Range | 8999478 |
| Interquartile range (IQR) | 8644754 |
Descriptive statistics
| Standard deviation | 4159106.568 |
|---|---|
| Coefficient of variation (CV) | 0.6906837598 |
| Kurtosis | -1.882188583 |
| Mean | 6021723.414 |
| Median Absolute Deviation (MAD) | 1075132 |
| Skewness | -0.2997551434 |
| Sum | 5.049877473 × 1011 |
| Variance | 1.729816744 × 1013 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 8672759 | 1 | < 0.1% |
| 1330221 | 1 | < 0.1% |
| 1776118 | 1 | < 0.1% |
| 1139193 | 1 | < 0.1% |
| 9788642 | 1 | < 0.1% |
| 9882175 | 1 | < 0.1% |
| 9877550 | 1 | < 0.1% |
| 9865732 | 1 | < 0.1% |
| 9863685 | 1 | < 0.1% |
| 1085561 | 1 | < 0.1% |
| Other values (83851) | 83851 |
| Value | Count | Frequency (%) |
| 1000011 | 1 | |
| 1000035 | 1 | |
| 1000036 | 1 | |
| 1000042 | 1 | |
| 1000045 | 1 |
| Value | Count | Frequency (%) |
| 9999489 | 1 | |
| 9999475 | 1 | |
| 9999454 | 1 | |
| 9999442 | 1 | |
| 9999430 | 1 |
| Distinct | 83861 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 370778655 |
|---|---|
| Minimum | 244461685 |
| Maximum | 503292427 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | 244461685 |
|---|---|
| 5-th percentile | 244724734 |
| Q1 | 322464917 |
| median | 380105016 |
| Q3 | 440276238 |
| 95-th percentile | 488921700 |
| Maximum | 503292427 |
| Range | 258830742 |
| Interquartile range (IQR) | 117811321 |
Descriptive statistics
| Standard deviation | 82703025.93 |
|---|---|
| Coefficient of variation (CV) | 0.2230522842 |
| Kurtosis | -1.130434276 |
| Mean | 370778655 |
| Median Absolute Deviation (MAD) | 58394464 |
| Skewness | -0.2702663046 |
| Sum | 3.109386879 × 1013 |
| Variance | 6.839790498 × 1015 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 447088639 | 1 | < 0.1% |
| 361716350 | 1 | < 0.1% |
| 339162901 | 1 | < 0.1% |
| 325034593 | 1 | < 0.1% |
| 321489508 | 1 | < 0.1% |
| 326385456 | 1 | < 0.1% |
| 416651878 | 1 | < 0.1% |
| 366580327 | 1 | < 0.1% |
| 244705896 | 1 | < 0.1% |
| 244789014 | 1 | < 0.1% |
| Other values (83851) | 83851 |
| Value | Count | Frequency (%) |
| 244461685 | 1 | |
| 244461708 | 1 | |
| 244461710 | 1 | |
| 244461712 | 1 | |
| 244461721 | 1 |
| Value | Count | Frequency (%) |
| 503292427 | 1 | |
| 503292406 | 1 | |
| 503292364 | 1 | |
| 503292356 | 1 | |
| 503292335 | 1 |
| Distinct | 83861 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| UK-9208474 | 1 |
|---|---|
| UK-1120645 | 1 |
| UK-9760950 | 1 |
| UK-1283661 | 1 |
| UK-9876472 | 1 |
| Other values (83856) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 838610 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 83861 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | UK-9877167 |
|---|---|
| 2nd row | UK-1177401 |
| 3rd row | UK-1051210 |
| 4th row | UK-1183042 |
| 5th row | UK-1083812 |
| Value | Count | Frequency (%) |
| UK-9208474 | 1 | < 0.1% |
| UK-1120645 | 1 | < 0.1% |
| UK-9760950 | 1 | < 0.1% |
| UK-1283661 | 1 | < 0.1% |
| UK-9876472 | 1 | < 0.1% |
| UK-9888297 | 1 | < 0.1% |
| UK-8775391 | 1 | < 0.1% |
| UK-8614004 | 1 | < 0.1% |
| UK-1288186 | 1 | < 0.1% |
| UK-8588579 | 1 | < 0.1% |
| Other values (83851) | 83851 |
| Value | Count | Frequency (%) |
| uk-9816655 | 1 | < 0.1% |
| uk-1196474 | 1 | < 0.1% |
| uk-9885438 | 1 | < 0.1% |
| uk-9659249 | 1 | < 0.1% |
| uk-9856095 | 1 | < 0.1% |
| uk-1285273 | 1 | < 0.1% |
| uk-9376284 | 1 | < 0.1% |
| uk-9855801 | 1 | < 0.1% |
| uk-9907491 | 1 | < 0.1% |
| uk-8587915 | 1 | < 0.1% |
| Other values (83851) | 83851 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 95328 | |
| 1 | 89503 | |
| U | 83861 | |
| K | 83861 | |
| - | 83861 | |
| 8 | 65271 | |
| 0 | 55684 | |
| 2 | 51289 | 6.1% |
| 3 | 48646 | 5.8% |
| 7 | 47562 | 5.7% |
| Other values (3) | 133744 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 587027 | |
| Uppercase Letter | 167722 | 20.0% |
| Dash Punctuation | 83861 | 10.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 9 | 95328 | |
| 1 | 89503 | |
| 8 | 65271 | |
| 0 | 55684 | |
| 2 | 51289 | |
| 3 | 48646 | |
| 7 | 47562 | |
| 4 | 45353 | |
| 5 | 44535 | |
| 6 | 43856 |
| Value | Count | Frequency (%) |
| U | 83861 | |
| K | 83861 |
| Value | Count | Frequency (%) |
| - | 83861 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 670888 | |
| Latin | 167722 | 20.0% |
Most frequent character per script
| Value | Count | Frequency (%) |
| 9 | 95328 | |
| 1 | 89503 | |
| - | 83861 | |
| 8 | 65271 | |
| 0 | 55684 | |
| 2 | 51289 | |
| 3 | 48646 | |
| 7 | 47562 | |
| 4 | 45353 | |
| 5 | 44535 |
| Value | Count | Frequency (%) |
| U | 83861 | |
| K | 83861 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 838610 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 9 | 95328 | |
| 1 | 89503 | |
| U | 83861 | |
| K | 83861 | |
| - | 83861 | |
| 8 | 65271 | |
| 0 | 55684 | |
| 2 | 51289 | 6.1% |
| 3 | 48646 | 5.8% |
| 7 | 47562 | 5.7% |
| Other values (3) | 133744 |
| Distinct | 44 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| Ford | |
|---|---|
| BMW | |
| Volkswagen | |
| Opel | |
| Audi | |
| Other values (39) |
Length
| Max length | 13 |
|---|---|
| Median length | 5 |
| Mean length | 6.035666162 |
| Min length | 2 |
Characters and Unicode
| Total characters | 506157 |
|---|---|
| Distinct characters | 46 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Peugeot |
|---|---|
| 2nd row | Peugeot |
| 3rd row | BMW |
| 4th row | BMW |
| 5th row | Nissan |
| Value | Count | Frequency (%) |
| Ford | 13637 | |
| BMW | 9572 | |
| Volkswagen | 9123 | |
| Opel | 7609 | |
| Audi | 6681 | 8.0% |
| Mercedes Benz | 6115 | 7.3% |
| Renault | 5138 | 6.1% |
| Toyota | 3222 | 3.8% |
| Nissan | 3029 | 3.6% |
| Peugeot | 3007 | 3.6% |
| Other values (34) | 16728 |
| Value | Count | Frequency (%) |
| ford | 13637 | |
| bmw | 9572 | |
| volkswagen | 9123 | |
| opel | 7609 | 8.3% |
| audi | 6681 | 7.3% |
| mercedes | 6115 | 6.7% |
| benz | 6115 | 6.7% |
| renault | 5138 | 5.6% |
| toyota | 3222 | 3.5% |
| nissan | 3029 | 3.3% |
| Other values (37) | 21484 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 59361 | 11.7% |
| o | 43529 | 8.6% |
| a | 31607 | 6.2% |
| d | 31603 | 6.2% |
| n | 29223 | 5.8% |
| r | 24641 | 4.9% |
| l | 24552 | 4.9% |
| s | 24199 | 4.8% |
| i | 18467 | 3.6% |
| M | 18344 | 3.6% |
| Other values (36) | 200631 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 387272 | |
| Uppercase Letter | 110985 | 21.9% |
| Space Separator | 7864 | 1.6% |
| Other Punctuation | 36 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 59361 | |
| o | 43529 | |
| a | 31607 | 8.2% |
| d | 31603 | 8.2% |
| n | 29223 | 7.5% |
| r | 24641 | 6.4% |
| l | 24552 | 6.3% |
| s | 24199 | 6.2% |
| i | 18467 | 4.8% |
| u | 18008 | 4.6% |
| Other values (14) | 82082 |
| Value | Count | Frequency (%) |
| M | 18344 | |
| B | 15687 | |
| F | 14015 | |
| V | 11345 | |
| W | 9572 | |
| O | 7609 | |
| A | 6905 | 6.2% |
| R | 6887 | 6.2% |
| S | 3470 | 3.1% |
| T | 3440 | 3.1% |
| Other values (9) | 13711 |
| Value | Count | Frequency (%) |
| / | 27 | |
| . | 9 | 25.0% |
| Value | Count | Frequency (%) |
| 7864 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 498257 | |
| Common | 7900 | 1.6% |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 59361 | 11.9% |
| o | 43529 | 8.7% |
| a | 31607 | 6.3% |
| d | 31603 | 6.3% |
| n | 29223 | 5.9% |
| r | 24641 | 4.9% |
| l | 24552 | 4.9% |
| s | 24199 | 4.9% |
| i | 18467 | 3.7% |
| M | 18344 | 3.7% |
| Other values (33) | 192731 |
| Value | Count | Frequency (%) |
| 7864 | ||
| / | 27 | 0.3% |
| . | 9 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 506157 |
Most frequent character per block
| Value | Count | Frequency (%) |
| e | 59361 | 11.7% |
| o | 43529 | 8.6% |
| a | 31607 | 6.2% |
| d | 31603 | 6.2% |
| n | 29223 | 5.8% |
| r | 24641 | 4.9% |
| l | 24552 | 4.9% |
| s | 24199 | 4.8% |
| i | 18467 | 3.6% |
| M | 18344 | 3.6% |
| Other values (36) | 200631 |
| Distinct | 4215 |
|---|---|
| Distinct (%) | 5.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| 2018-03-31 | 556 |
|---|---|
| 2017-03-31 | 460 |
| 2018-04-30 | 398 |
| 2015-09-30 | 324 |
| 2016-03-31 | 299 |
| Other values (4210) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 838610 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 431 ? |
|---|---|
| Unique (%) | 0.5% |
Sample
| 1st row | 2013-12-31 |
|---|---|
| 2nd row | 2013-12-31 |
| 3rd row | 2016-03-31 |
| 4th row | 2016-03-31 |
| 5th row | 2016-07-31 |
| Value | Count | Frequency (%) |
| 2018-03-31 | 556 | 0.7% |
| 2017-03-31 | 460 | 0.5% |
| 2018-04-30 | 398 | 0.5% |
| 2015-09-30 | 324 | 0.4% |
| 2016-03-31 | 299 | 0.4% |
| 2016-06-30 | 248 | 0.3% |
| 2016-05-31 | 215 | 0.3% |
| 2017-06-30 | 202 | 0.2% |
| 2014-09-30 | 195 | 0.2% |
| 2014-05-28 | 185 | 0.2% |
| Other values (4205) | 80779 |
| Value | Count | Frequency (%) |
| 2018-03-31 | 556 | 0.7% |
| 2017-03-31 | 460 | 0.5% |
| 2018-04-30 | 398 | 0.5% |
| 2015-09-30 | 324 | 0.4% |
| 2016-03-31 | 299 | 0.4% |
| 2016-06-30 | 248 | 0.3% |
| 2016-05-31 | 215 | 0.3% |
| 2017-06-30 | 202 | 0.2% |
| 2014-09-30 | 195 | 0.2% |
| 2014-05-28 | 185 | 0.2% |
| Other values (4205) | 80779 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 201070 | |
| - | 167722 | |
| 1 | 155062 | |
| 2 | 137988 | |
| 3 | 37607 | 4.5% |
| 6 | 25271 | 3.0% |
| 5 | 24444 | 2.9% |
| 9 | 23345 | 2.8% |
| 7 | 23148 | 2.8% |
| 4 | 21807 | 2.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 670888 | |
| Dash Punctuation | 167722 | 20.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 201070 | |
| 1 | 155062 | |
| 2 | 137988 | |
| 3 | 37607 | 5.6% |
| 6 | 25271 | 3.8% |
| 5 | 24444 | 3.6% |
| 9 | 23345 | 3.5% |
| 7 | 23148 | 3.5% |
| 4 | 21807 | 3.3% |
| 8 | 21146 | 3.2% |
| Value | Count | Frequency (%) |
| - | 167722 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 838610 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 201070 | |
| - | 167722 | |
| 1 | 155062 | |
| 2 | 137988 | |
| 3 | 37607 | 4.5% |
| 6 | 25271 | 3.0% |
| 5 | 24444 | 2.9% |
| 9 | 23345 | 2.8% |
| 7 | 23148 | 2.8% |
| 4 | 21807 | 2.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 838610 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 201070 | |
| - | 167722 | |
| 1 | 155062 | |
| 2 | 137988 | |
| 3 | 37607 | 4.5% |
| 6 | 25271 | 3.0% |
| 5 | 24444 | 2.9% |
| 9 | 23345 | 2.8% |
| 7 | 23148 | 2.8% |
| 4 | 21807 | 2.6% |
| Distinct | 433 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| TRANSIT | 3862 |
|---|---|
| 3 SERIES | 3796 |
| GOLF | 3752 |
| FOCUS | 2551 |
| CORSA | 2288 |
| Other values (428) |
Length
| Max length | 24 |
|---|---|
| Median length | 6 |
| Mean length | 6.404669632 |
| Min length | 2 |
Characters and Unicode
| Total characters | 537102 |
|---|---|
| Distinct characters | 53 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 52 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | BIPPER |
|---|---|
| 2nd row | BIPPER |
| 3rd row | 4 SERIES |
| 4th row | 4 SERIES |
| 5th row | NP300 |
| Value | Count | Frequency (%) |
| TRANSIT | 3862 | 4.6% |
| 3 SERIES | 3796 | 4.5% |
| GOLF | 3752 | 4.5% |
| FOCUS | 2551 | 3.0% |
| CORSA | 2288 | 2.7% |
| A3 | 2232 | 2.7% |
| PASSAT | 2138 | 2.5% |
| TRANSIT CUSTOM | 2055 | 2.5% |
| 5 SERIES | 2010 | 2.4% |
| A4 | 1894 | 2.3% |
| Other values (423) | 57283 |
| Value | Count | Frequency (%) |
| series | 8191 | 8.1% |
| transit | 7519 | 7.5% |
| 3 | 3796 | 3.8% |
| golf | 3756 | 3.7% |
| focus | 2551 | 2.5% |
| passat | 2478 | 2.5% |
| corsa | 2288 | 2.3% |
| a3 | 2232 | 2.2% |
| custom | 2133 | 2.1% |
| 5 | 2010 | 2.0% |
| Other values (423) | 63741 |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 61402 | |
| A | 59698 | |
| R | 44043 | 8.2% |
| E | 41246 | 7.7% |
| I | 38429 | 7.2% |
| T | 37562 | 7.0% |
| O | 32036 | 6.0% |
| N | 28701 | 5.3% |
| C | 28270 | 5.3% |
| 16834 | 3.1% | |
| Other values (43) | 148881 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 481655 | |
| Decimal Number | 30061 | 5.6% |
| Space Separator | 16834 | 3.1% |
| Dash Punctuation | 6354 | 1.2% |
| Other Punctuation | 1154 | 0.2% |
| Lowercase Letter | 868 | 0.2% |
| Math Symbol | 172 | < 0.1% |
| Open Punctuation | 2 | < 0.1% |
| Close Punctuation | 2 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| S | 61402 | |
| A | 59698 | |
| R | 44043 | |
| E | 41246 | |
| I | 38429 | |
| T | 37562 | |
| O | 32036 | 6.7% |
| N | 28701 | 6.0% |
| C | 28270 | 5.9% |
| L | 16377 | 3.4% |
| Other values (16) | 93891 |
| Value | Count | Frequency (%) |
| 3 | 7806 | |
| 0 | 5820 | |
| 5 | 4166 | |
| 4 | 3570 | |
| 1 | 2533 | 8.4% |
| 6 | 2312 | 7.7% |
| 2 | 1955 | 6.5% |
| 8 | 1219 | 4.1% |
| 7 | 447 | 1.5% |
| 9 | 233 | 0.8% |
| Value | Count | Frequency (%) |
| o | 186 | |
| t | 124 | |
| d | 124 | |
| c | 62 | 7.1% |
| n | 62 | 7.1% |
| s | 62 | 7.1% |
| l | 62 | 7.1% |
| i | 62 | 7.1% |
| a | 62 | 7.1% |
| e | 62 | 7.1% |
| Value | Count | Frequency (%) |
| / | 1108 | |
| ' | 46 | 4.0% |
| Value | Count | Frequency (%) |
| 16834 |
| Value | Count | Frequency (%) |
| - | 6354 |
| Value | Count | Frequency (%) |
| + | 172 |
| Value | Count | Frequency (%) |
| ( | 2 |
| Value | Count | Frequency (%) |
| ) | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 482523 | |
| Common | 54579 | 10.2% |
Most frequent character per script
| Value | Count | Frequency (%) |
| S | 61402 | |
| A | 59698 | |
| R | 44043 | |
| E | 41246 | |
| I | 38429 | |
| T | 37562 | 7.8% |
| O | 32036 | 6.6% |
| N | 28701 | 5.9% |
| C | 28270 | 5.9% |
| L | 16377 | 3.4% |
| Other values (26) | 94759 |
| Value | Count | Frequency (%) |
| 16834 | ||
| 3 | 7806 | |
| - | 6354 | 11.6% |
| 0 | 5820 | 10.7% |
| 5 | 4166 | 7.6% |
| 4 | 3570 | 6.5% |
| 1 | 2533 | 4.6% |
| 6 | 2312 | 4.2% |
| 2 | 1955 | 3.6% |
| 8 | 1219 | 2.2% |
| Other values (7) | 2010 | 3.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 537102 |
Most frequent character per block
| Value | Count | Frequency (%) |
| S | 61402 | |
| A | 59698 | |
| R | 44043 | 8.2% |
| E | 41246 | 7.7% |
| I | 38429 | 7.2% |
| T | 37562 | 7.0% |
| O | 32036 | 6.0% |
| N | 28701 | 5.3% |
| C | 28270 | 5.3% |
| 16834 | 3.1% | |
| Other values (43) | 148881 |
| Distinct | 8914 |
|---|---|
| Distinct (%) | 10.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| 1.3D LIFE | 1041 |
|---|---|
| M SPORT | 579 |
| 1.0T140 ST-LNNV | 534 |
| SPORT | 474 |
| SE | 463 |
| Other values (8909) |
Length
| Max length | 15 |
|---|---|
| Median length | 13 |
| Mean length | 11.85089613 |
| Min length | 1 |
Characters and Unicode
| Total characters | 993828 |
|---|---|
| Distinct characters | 70 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2909 ? |
|---|---|
| Unique (%) | 3.5% |
Sample
| 1st row | 1.3D75 PROF |
|---|---|
| 2nd row | 1.3D75 PROF |
| 3rd row | 2.0 M SPT PRF A |
| 4th row | 2.0 M SPT PRF A |
| 5th row | 190 D/C TEKNA A |
| Value | Count | Frequency (%) |
| 1.3D LIFE | 1041 | 1.2% |
| M SPORT | 579 | 0.7% |
| 1.0T140 ST-LNNV | 534 | 0.6% |
| SPORT | 474 | 0.6% |
| SE | 463 | 0.6% |
| 2.0d SE | 443 | 0.5% |
| M SPORT St | 433 | 0.5% |
| 2.2D100L | 418 | 0.5% |
| 2.2D85L | 408 | 0.5% |
| 2.0d EFFCT DYNS | 406 | 0.5% |
| Other values (8904) | 78662 |
| Value | Count | Frequency (%) |
| se | 12532 | 5.9% |
| 2.0d | 8220 | 3.9% |
| 1.6d | 6718 | 3.2% |
| sport | 6707 | 3.2% |
| m | 3358 | 1.6% |
| nav | 2911 | 1.4% |
| bus | 2746 | 1.3% |
| au | 2703 | 1.3% |
| 2.0 | 2590 | 1.2% |
| 1.5d | 2488 | 1.2% |
| Other values (3026) | 160429 |
Most occurring characters
| Value | Count | Frequency (%) |
| 127829 | 12.9% | |
| . | 64425 | 6.5% |
| 1 | 63601 | 6.4% |
| E | 54072 | 5.4% |
| 2 | 53626 | 5.4% |
| D | 53418 | 5.4% |
| T | 52837 | 5.3% |
| 0 | 52473 | 5.3% |
| S | 50517 | 5.1% |
| L | 28254 | 2.8% |
| Other values (60) | 392776 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 488154 | |
| Decimal Number | 252640 | |
| Space Separator | 127829 | 12.9% |
| Other Punctuation | 71463 | 7.2% |
| Lowercase Letter | 46009 | 4.6% |
| Dash Punctuation | 4945 | 0.5% |
| Math Symbol | 2592 | 0.3% |
| Open Punctuation | 98 | < 0.1% |
| Close Punctuation | 98 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| E | 54072 | |
| D | 53418 | 10.9% |
| T | 52837 | 10.8% |
| S | 50517 | 10.3% |
| L | 28254 | 5.8% |
| N | 27520 | 5.6% |
| R | 23736 | 4.9% |
| C | 22273 | 4.6% |
| P | 20673 | 4.2% |
| A | 20081 | 4.1% |
| Other values (16) | 134773 |
| Value | Count | Frequency (%) |
| d | 18873 | |
| i | 6060 | 13.2% |
| e | 3379 | 7.3% |
| t | 3106 | 6.8% |
| s | 2915 | 6.3% |
| p | 1953 | 4.2% |
| f | 1919 | 4.2% |
| h | 1296 | 2.8% |
| n | 1053 | 2.3% |
| y | 927 | 2.0% |
| Other values (14) | 4528 | 9.8% |
| Value | Count | Frequency (%) |
| 1 | 63601 | |
| 2 | 53626 | |
| 0 | 52473 | |
| 5 | 22133 | 8.8% |
| 6 | 15569 | 6.2% |
| 3 | 14425 | 5.7% |
| 4 | 11385 | 4.5% |
| 7 | 7325 | 2.9% |
| 9 | 6530 | 2.6% |
| 8 | 5573 | 2.2% |
| Value | Count | Frequency (%) |
| . | 64425 | |
| / | 6902 | 9.7% |
| & | 77 | 0.1% |
| " | 53 | 0.1% |
| \ | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 127829 |
| Value | Count | Frequency (%) |
| - | 4945 |
| Value | Count | Frequency (%) |
| + | 2592 |
| Value | Count | Frequency (%) |
| ( | 98 |
| Value | Count | Frequency (%) |
| ) | 98 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 534163 | |
| Common | 459665 |
Most frequent character per script
| Value | Count | Frequency (%) |
| E | 54072 | 10.1% |
| D | 53418 | 10.0% |
| T | 52837 | 9.9% |
| S | 50517 | 9.5% |
| L | 28254 | 5.3% |
| N | 27520 | 5.2% |
| R | 23736 | 4.4% |
| C | 22273 | 4.2% |
| P | 20673 | 3.9% |
| A | 20081 | 3.8% |
| Other values (40) | 180782 |
| Value | Count | Frequency (%) |
| 127829 | ||
| . | 64425 | |
| 1 | 63601 | |
| 2 | 53626 | |
| 0 | 52473 | |
| 5 | 22133 | 4.8% |
| 6 | 15569 | 3.4% |
| 3 | 14425 | 3.1% |
| 4 | 11385 | 2.5% |
| 7 | 7325 | 1.6% |
| Other values (10) | 26874 | 5.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 993828 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 127829 | 12.9% | |
| . | 64425 | 6.5% |
| 1 | 63601 | 6.4% |
| E | 54072 | 5.4% |
| 2 | 53626 | 5.4% |
| D | 53418 | 5.4% |
| T | 52837 | 5.3% |
| 0 | 52473 | 5.3% |
| S | 50517 | 5.1% |
| L | 28254 | 2.8% |
| Other values (60) | 392776 |
| Distinct | 22 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| VAG | |
|---|---|
| Ford Motor Co. | |
| BMW Group | |
| Renault-Nissan | |
| GM | |
| Other values (17) |
Length
| Max length | 31 |
|---|---|
| Median length | 9 |
| Mean length | 8.495248089 |
| Min length | 2 |
Characters and Unicode
| Total characters | 712420 |
|---|---|
| Distinct characters | 39 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PSA |
|---|---|
| 2nd row | PSA |
| 3rd row | BMW Group |
| 4th row | BMW Group |
| 5th row | Renault-Nissan |
| Value | Count | Frequency (%) |
| VAG | 19133 | |
| Ford Motor Co. | 13637 | |
| BMW Group | 10281 | |
| Renault-Nissan | 8202 | |
| GM | 7709 | |
| Daimler AG | 6142 | 7.3% |
| PSA | 5422 | 6.5% |
| Toyota Motor Co | 3704 | 4.4% |
| Tata Group | 2383 | 2.8% |
| Geely Group | 2222 | 2.6% |
| Other values (12) | 5026 | 6.0% |
| Value | Count | Frequency (%) |
| vag | 19133 | |
| motor | 18765 | |
| co | 17903 | |
| group | 16852 | |
| ford | 13637 | |
| bmw | 10281 | |
| renault-nissan | 8202 | |
| gm | 7709 | 5.3% |
| ag | 6142 | 4.2% |
| daimler | 6142 | 4.2% |
| Other values (20) | 20074 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 95386 | 13.4% |
| 60979 | 8.6% | |
| r | 56684 | 8.0% |
| G | 52058 | 7.3% |
| M | 38888 | 5.5% |
| a | 35839 | 5.0% |
| t | 35367 | 5.0% |
| A | 30858 | 4.3% |
| u | 26795 | 3.8% |
| i | 19828 | 2.8% |
| Other values (29) | 259738 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 392144 | |
| Uppercase Letter | 236729 | |
| Space Separator | 60979 | 8.6% |
| Other Punctuation | 14208 | 2.0% |
| Dash Punctuation | 8202 | 1.2% |
| Open Punctuation | 79 | < 0.1% |
| Close Punctuation | 79 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| o | 95386 | |
| r | 56684 | |
| a | 35839 | 9.1% |
| t | 35367 | 9.0% |
| u | 26795 | 6.8% |
| i | 19828 | 5.1% |
| e | 19202 | 4.9% |
| s | 19136 | 4.9% |
| p | 17714 | 4.5% |
| n | 17554 | 4.5% |
| Other values (8) | 48639 |
| Value | Count | Frequency (%) |
| G | 52058 | |
| M | 38888 | |
| A | 30858 | |
| V | 19133 | 8.1% |
| C | 18923 | 8.0% |
| F | 14682 | 6.2% |
| B | 10281 | 4.3% |
| W | 10281 | 4.3% |
| N | 8205 | 3.5% |
| R | 8202 | 3.5% |
| Other values (6) | 25218 |
| Value | Count | Frequency (%) |
| 60979 |
| Value | Count | Frequency (%) |
| - | 8202 |
| Value | Count | Frequency (%) |
| . | 14208 |
| Value | Count | Frequency (%) |
| ( | 79 |
| Value | Count | Frequency (%) |
| ) | 79 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 628873 | |
| Common | 83547 | 11.7% |
Most frequent character per script
| Value | Count | Frequency (%) |
| o | 95386 | |
| r | 56684 | 9.0% |
| G | 52058 | 8.3% |
| M | 38888 | 6.2% |
| a | 35839 | 5.7% |
| t | 35367 | 5.6% |
| A | 30858 | 4.9% |
| u | 26795 | 4.3% |
| i | 19828 | 3.2% |
| e | 19202 | 3.1% |
| Other values (24) | 217968 |
| Value | Count | Frequency (%) |
| 60979 | ||
| . | 14208 | 17.0% |
| - | 8202 | 9.8% |
| ( | 79 | 0.1% |
| ) | 79 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 712420 |
Most frequent character per block
| Value | Count | Frequency (%) |
| o | 95386 | 13.4% |
| 60979 | 8.6% | |
| r | 56684 | 8.0% |
| G | 52058 | 7.3% |
| M | 38888 | 5.5% |
| a | 35839 | 5.0% |
| t | 35367 | 5.0% |
| A | 30858 | 4.3% |
| u | 26795 | 3.8% |
| i | 19828 | 2.8% |
| Other values (29) | 259738 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| Car | |
|---|---|
| Van |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 251583 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Van |
|---|---|
| 2nd row | Van |
| 3rd row | Car |
| 4th row | Car |
| 5th row | Van |
| Value | Count | Frequency (%) |
| Car | 60943 | |
| Van | 22918 | 27.3% |
| Value | Count | Frequency (%) |
| car | 60943 | |
| van | 22918 | 27.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 83861 | |
| C | 60943 | |
| r | 60943 | |
| V | 22918 | 9.1% |
| n | 22918 | 9.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 167722 | |
| Uppercase Letter | 83861 |
Most frequent character per category
| Value | Count | Frequency (%) |
| a | 83861 | |
| r | 60943 | |
| n | 22918 | 13.7% |
| Value | Count | Frequency (%) |
| C | 60943 | |
| V | 22918 | 27.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 251583 |
Most frequent character per script
| Value | Count | Frequency (%) |
| a | 83861 | |
| C | 60943 | |
| r | 60943 | |
| V | 22918 | 9.1% |
| n | 22918 | 9.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 251583 |
Most frequent character per block
| Value | Count | Frequency (%) |
| a | 83861 | |
| C | 60943 | |
| r | 60943 | |
| V | 22918 | 9.1% |
| n | 22918 | 9.1% |
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| Compact car | |
|---|---|
| Medium car | |
| Commercial van | |
| SUV | |
| Small car | |
| Other values (11) |
Length
| Max length | 22 |
|---|---|
| Median length | 11 |
| Mean length | 10.51235974 |
| Min length | 3 |
Characters and Unicode
| Total characters | 881577 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Car derived van |
|---|---|
| 2nd row | Car derived van |
| 3rd row | Medium car |
| 4th row | Medium car |
| 5th row | Other Van |
| Value | Count | Frequency (%) |
| Compact car | 18555 | |
| Medium car | 17354 | |
| Commercial van | 14582 | |
| SUV | 10714 | |
| Small car | 7148 | 8.5% |
| Car derived van | 5417 | 6.5% |
| Executive car | 5038 | 6.0% |
| Other Van | 1685 | 2.0% |
| Not consolidated | 872 | 1.0% |
| Other Car | 786 | 0.9% |
| Other values (6) | 1710 | 2.0% |
| Value | Count | Frequency (%) |
| car | 55100 | |
| van | 21767 | 13.4% |
| compact | 18555 | 11.4% |
| medium | 17354 | 10.7% |
| commercial | 15320 | 9.4% |
| suv | 10714 | 6.6% |
| small | 7148 | 4.4% |
| derived | 6155 | 3.8% |
| executive | 5038 | 3.1% |
| other | 2471 | 1.5% |
| Other values (6) | 2807 | 1.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 118853 | |
| c | 88674 | 10.1% |
| r | 79102 | 9.0% |
| 78568 | 8.9% | |
| m | 73697 | 8.4% |
| e | 58403 | 6.6% |
| i | 44739 | 5.1% |
| C | 40086 | 4.5% |
| o | 36652 | 4.2% |
| d | 31408 | 3.6% |
| Other values (21) | 231395 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 693648 | |
| Uppercase Letter | 109361 | 12.4% |
| Space Separator | 78568 | 8.9% |
Most frequent character per category
| Value | Count | Frequency (%) |
| a | 118853 | |
| c | 88674 | |
| r | 79102 | |
| m | 73697 | |
| e | 58403 | |
| i | 44739 | 6.4% |
| o | 36652 | 5.3% |
| d | 31408 | 4.5% |
| v | 31192 | 4.5% |
| l | 30488 | 4.4% |
| Other values (10) | 100440 |
| Value | Count | Frequency (%) |
| C | 40086 | |
| M | 18109 | |
| S | 17862 | |
| V | 13237 | 12.1% |
| U | 10784 | 9.9% |
| E | 5038 | 4.6% |
| O | 2471 | 2.3% |
| N | 963 | 0.9% |
| P | 755 | 0.7% |
| L | 56 | 0.1% |
| Value | Count | Frequency (%) |
| 78568 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 803009 | |
| Common | 78568 | 8.9% |
Most frequent character per script
| Value | Count | Frequency (%) |
| a | 118853 | |
| c | 88674 | |
| r | 79102 | 9.9% |
| m | 73697 | 9.2% |
| e | 58403 | 7.3% |
| i | 44739 | 5.6% |
| C | 40086 | 5.0% |
| o | 36652 | 4.6% |
| d | 31408 | 3.9% |
| v | 31192 | 3.9% |
| Other values (20) | 200203 |
| Value | Count | Frequency (%) |
| 78568 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 881577 |
Most frequent character per block
| Value | Count | Frequency (%) |
| a | 118853 | |
| c | 88674 | 10.1% |
| r | 79102 | 9.0% |
| 78568 | 8.9% | |
| m | 73697 | 8.4% |
| e | 58403 | 6.6% |
| i | 44739 | 5.1% |
| C | 40086 | 4.5% |
| o | 36652 | 4.2% |
| d | 31408 | 3.6% |
| Other values (21) | 231395 |
primary_fuel_type_cons
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| Diesel | |
|---|---|
| Petrol | |
| Electric | 3494 |
| LPG | 51 |
Length
| Max length | 8 |
|---|---|
| Median length | 6 |
| Mean length | 6.081503917 |
| Min length | 3 |
Characters and Unicode
| Total characters | 510001 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Diesel |
|---|---|
| 2nd row | Diesel |
| 3rd row | Diesel |
| 4th row | Diesel |
| 5th row | Diesel |
| Value | Count | Frequency (%) |
| Diesel | 68612 | |
| Petrol | 11704 | 14.0% |
| Electric | 3494 | 4.2% |
| LPG | 51 | 0.1% |
| Value | Count | Frequency (%) |
| diesel | 68612 | |
| petrol | 11704 | 14.0% |
| electric | 3494 | 4.2% |
| lpg | 51 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 152422 | |
| l | 83810 | |
| i | 72106 | |
| D | 68612 | |
| s | 68612 | |
| t | 15198 | 3.0% |
| r | 15198 | 3.0% |
| P | 11755 | 2.3% |
| o | 11704 | 2.3% |
| c | 6988 | 1.4% |
| Other values (3) | 3596 | 0.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 426038 | |
| Uppercase Letter | 83963 | 16.5% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 152422 | |
| l | 83810 | |
| i | 72106 | |
| s | 68612 | |
| t | 15198 | 3.6% |
| r | 15198 | 3.6% |
| o | 11704 | 2.7% |
| c | 6988 | 1.6% |
| Value | Count | Frequency (%) |
| D | 68612 | |
| P | 11755 | 14.0% |
| E | 3494 | 4.2% |
| L | 51 | 0.1% |
| G | 51 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 510001 |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 152422 | |
| l | 83810 | |
| i | 72106 | |
| D | 68612 | |
| s | 68612 | |
| t | 15198 | 3.0% |
| r | 15198 | 3.0% |
| P | 11755 | 2.3% |
| o | 11704 | 2.3% |
| c | 6988 | 1.4% |
| Other values (3) | 3596 | 0.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 510001 |
Most frequent character per block
| Value | Count | Frequency (%) |
| e | 152422 | |
| l | 83810 | |
| i | 72106 | |
| D | 68612 | |
| s | 68612 | |
| t | 15198 | 3.0% |
| r | 15198 | 3.0% |
| P | 11755 | 2.3% |
| o | 11704 | 2.3% |
| c | 6988 | 1.4% |
| Other values (3) | 3596 | 0.7% |
| Distinct | 176 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.005546082 |
|---|---|
| Minimum | 0 |
| Maximum | 100 |
| Zeros | 49765 |
| Zeros (%) | 59.3% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1.56 |
| 95-th percentile | 2.34 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 1.56 |
Descriptive statistics
| Standard deviation | 5.516054246 |
|---|---|
| Coefficient of variation (CV) | 5.485630489 |
| Kurtosis | 308.7688061 |
| Mean | 1.005546082 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 17.37494842 |
| Sum | 84326.1 |
| Variance | 30.42685445 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 49765 | |
| 1.52 | 2012 | 2.4% |
| 1.45 | 1479 | 1.8% |
| 1.59 | 1476 | 1.8% |
| 1.35 | 1303 | 1.6% |
| 1.49 | 1265 | 1.5% |
| 1.42 | 1240 | 1.5% |
| 1.66 | 1170 | 1.4% |
| 1.84 | 1095 | 1.3% |
| 1.56 | 1063 | 1.3% |
| Other values (166) | 21993 |
| Value | Count | Frequency (%) |
| 0 | 49765 | |
| 0.21 | 23 | < 0.1% |
| 0.25 | 6 | < 0.1% |
| 0.39 | 10 | < 0.1% |
| 0.42 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 100 | 252 | |
| 17.24 | 20 | < 0.1% |
| 4.52 | 1 | < 0.1% |
| 4.35 | 2 | < 0.1% |
| 4.22 | 1 | < 0.1% |
cat_price_euro
Real number (ℝ≥0)
| Distinct | 10247 |
|---|---|
| Distinct (%) | 12.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23824.026 |
|---|---|
| Minimum | 1.11 |
| Maximum | 120815.27 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | 1.11 |
|---|---|
| 5-th percentile | 12479.92 |
| Q1 | 18775.47 |
| median | 22726.98 |
| Q3 | 28295.23 |
| 95-th percentile | 36564.22 |
| Maximum | 120815.27 |
| Range | 120814.16 |
| Interquartile range (IQR) | 9519.76 |
Descriptive statistics
| Standard deviation | 7937.687993 |
|---|---|
| Coefficient of variation (CV) | 0.3331799584 |
| Kurtosis | 5.388476221 |
| Mean | 23824.026 |
| Median Absolute Deviation (MAD) | 4609.32 |
| Skewness | 1.251400156 |
| Sum | 1997906645 |
| Variance | 63006890.67 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 9369.36 | 1034 | 1.2% |
| 19979.91 | 546 | 0.7% |
| 21229.76 | 312 | 0.4% |
| 25126.61 | 301 | 0.4% |
| 19906.72 | 279 | 0.3% |
| 9714.73 | 209 | 0.2% |
| 14953.66 | 208 | 0.2% |
| 26677.56 | 195 | 0.2% |
| 24248.29 | 194 | 0.2% |
| 38990.72 | 182 | 0.2% |
| Other values (10237) | 80401 |
| Value | Count | Frequency (%) |
| 1.11 | 11 | |
| 5959.23 | 1 | < 0.1% |
| 6198.77 | 3 | < 0.1% |
| 6429.88 | 1 | < 0.1% |
| 6572.57 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 120815.27 | 1 | < 0.1% |
| 107293.04 | 2 | |
| 102895.63 | 2 | |
| 99575.31 | 1 | < 0.1% |
| 96179.7 | 3 |
| Distinct | 18360 |
|---|---|
| Distinct (%) | 21.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 503.3524755 |
|---|---|
| Minimum | -137.86 |
| Maximum | 18942.18 |
| Zeros | 37607 |
| Zeros (%) | 44.8% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | -137.86 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 178.83 |
| Q3 | 576.46 |
| 95-th percentile | 2165.7 |
| Maximum | 18942.18 |
| Range | 19080.04 |
| Interquartile range (IQR) | 576.46 |
Descriptive statistics
| Standard deviation | 900.8711171 |
|---|---|
| Coefficient of variation (CV) | 1.789742101 |
| Kurtosis | 37.93733427 |
| Mean | 503.3524755 |
| Median Absolute Deviation (MAD) | 178.83 |
| Skewness | 4.481621141 |
| Sum | 42211641.95 |
| Variance | 811568.7697 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 37607 | |
| 171.08 | 603 | 0.7% |
| 486.41 | 260 | 0.3% |
| 478.07 | 225 | 0.3% |
| 458.61 | 221 | 0.3% |
| 111.17 | 211 | 0.3% |
| 417.34 | 196 | 0.2% |
| 437.21 | 174 | 0.2% |
| 500.3 | 173 | 0.2% |
| 504.94 | 156 | 0.2% |
| Other values (18350) | 44035 |
| Value | Count | Frequency (%) |
| -137.86 | 1 | < 0.1% |
| -49.75 | 3 | < 0.1% |
| 0 | 37607 | |
| 0.37 | 1 | < 0.1% |
| 2.83 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 18942.18 | 1 | |
| 18378 | 2 | |
| 16468.49 | 2 | |
| 16167.39 | 1 | |
| 16121.05 | 1 |
| Distinct | 4463 |
|---|---|
| Distinct (%) | 5.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 546.7760669 |
|---|---|
| Minimum | 0 |
| Maximum | 86587.86 |
| Zeros | 64618 |
| Zeros (%) | 77.1% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 3342.07 |
| Maximum | 86587.86 |
| Range | 86587.86 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2096.997024 |
|---|---|
| Coefficient of variation (CV) | 3.835202656 |
| Kurtosis | 309.0504976 |
| Mean | 546.7760669 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.69753734 |
| Sum | 45853187.75 |
| Variance | 4397396.52 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 64618 | |
| 157.87 | 644 | 0.8% |
| 360.72 | 409 | 0.5% |
| 189 | 385 | 0.5% |
| 5.83 | 316 | 0.4% |
| 118.29 | 254 | 0.3% |
| 203.45 | 240 | 0.3% |
| 2473.17 | 198 | 0.2% |
| 222.35 | 129 | 0.2% |
| 753.98 | 125 | 0.1% |
| Other values (4453) | 16543 | 19.7% |
| Value | Count | Frequency (%) |
| 0 | 64618 | |
| 0.01 | 17 | < 0.1% |
| 0.02 | 1 | < 0.1% |
| 0.88 | 1 | < 0.1% |
| 1.11 | 27 | < 0.1% |
| Value | Count | Frequency (%) |
| 86587.86 | 2 | |
| 84364.26 | 3 | |
| 83697.19 | 3 | |
| 57505.47 | 1 | < 0.1% |
| 46289.66 | 3 |
product_name_cons
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| Full service Closed calculation | |
|---|---|
| Open Calculation | |
| Finance Only | 62 |
Length
| Max length | 31 |
|---|---|
| Median length | 31 |
| Mean length | 23.70515496 |
| Min length | 12 |
Characters and Unicode
| Total characters | 1987938 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Full service Closed calculation |
|---|---|
| 2nd row | Full service Closed calculation |
| 3rd row | Full service Closed calculation |
| 4th row | Full service Closed calculation |
| 5th row | Full service Closed calculation |
| Value | Count | Frequency (%) |
| Full service Closed calculation | 43094 | |
| Open Calculation | 40705 | |
| Finance Only | 62 | 0.1% |
| Value | Count | Frequency (%) |
| calculation | 83799 | |
| closed | 43094 | |
| full | 43094 | |
| service | 43094 | |
| open | 40705 | |
| finance | 62 | < 0.1% |
| only | 62 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 296942 | |
| 170049 | ||
| e | 170049 | |
| c | 170049 | |
| a | 167660 | 8.4% |
| i | 126955 | 6.4% |
| u | 126893 | 6.4% |
| o | 126893 | 6.4% |
| n | 124690 | 6.3% |
| s | 86188 | 4.3% |
| Other values (9) | 421570 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1650167 | |
| Space Separator | 170049 | 8.6% |
| Uppercase Letter | 167722 | 8.4% |
Most frequent character per category
| Value | Count | Frequency (%) |
| l | 296942 | |
| e | 170049 | |
| c | 170049 | |
| a | 167660 | |
| i | 126955 | |
| u | 126893 | |
| o | 126893 | |
| n | 124690 | |
| s | 86188 | 5.2% |
| t | 83799 | 5.1% |
| Other values (5) | 170049 |
| Value | Count | Frequency (%) |
| C | 83799 | |
| F | 43156 | |
| O | 40767 |
| Value | Count | Frequency (%) |
| 170049 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1817889 | |
| Common | 170049 | 8.6% |
Most frequent character per script
| Value | Count | Frequency (%) |
| l | 296942 | |
| e | 170049 | |
| c | 170049 | |
| a | 167660 | |
| i | 126955 | 7.0% |
| u | 126893 | 7.0% |
| o | 126893 | 7.0% |
| n | 124690 | 6.9% |
| s | 86188 | 4.7% |
| C | 83799 | 4.6% |
| Other values (8) | 337771 |
| Value | Count | Frequency (%) |
| 170049 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1987938 |
Most frequent character per block
| Value | Count | Frequency (%) |
| l | 296942 | |
| 170049 | ||
| e | 170049 | |
| c | 170049 | |
| a | 167660 | 8.4% |
| i | 126955 | 6.4% |
| u | 126893 | 6.4% |
| o | 126893 | 6.4% |
| n | 124690 | 6.3% |
| s | 86188 | 4.3% |
| Other values (9) | 421570 |
engine_capacity
Real number (ℝ≥0)
| Distinct | 215 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1831.290087 |
|---|---|
| Minimum | 1 |
| Maximum | 5513 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1229 |
| Q1 | 1560 |
| median | 1968 |
| Q3 | 1998 |
| 95-th percentile | 2402 |
| Maximum | 5513 |
| Range | 5512 |
| Interquartile range (IQR) | 438 |
Descriptive statistics
| Standard deviation | 423.2748694 |
|---|---|
| Coefficient of variation (CV) | 0.2311348007 |
| Kurtosis | 4.236574638 |
| Mean | 1831.290087 |
| Median Absolute Deviation (MAD) | 230 |
| Skewness | -0.4251176918 |
| Sum | 153573818 |
| Variance | 179161.615 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1968 | 10498 | 12.5% |
| 1598 | 9272 | 11.1% |
| 1995 | 7555 | 9.0% |
| 1560 | 4951 | 5.9% |
| 2198 | 4623 | 5.5% |
| 1461 | 3733 | 4.5% |
| 2143 | 3660 | 4.4% |
| 1998 | 2565 | 3.1% |
| 1997 | 2348 | 2.8% |
| 1248 | 2295 | 2.7% |
| Other values (205) | 32361 |
| Value | Count | Frequency (%) |
| 1 | 908 | |
| 698 | 2 | < 0.1% |
| 799 | 2 | < 0.1% |
| 875 | 15 | < 0.1% |
| 898 | 50 | 0.1% |
| Value | Count | Frequency (%) |
| 5513 | 2 | < 0.1% |
| 5461 | 3 | < 0.1% |
| 5000 | 5 | < 0.1% |
| 4663 | 6 | |
| 4367 | 13 |
engine_power
Real number (ℝ≥0)
| Distinct | 198 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 101.4672017 |
|---|---|
| Minimum | 0 |
| Maximum | 508 |
| Zeros | 38 |
| Zeros (%) | < 0.1% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 55 |
| Q1 | 80 |
| median | 96 |
| Q3 | 120 |
| 95-th percentile | 163 |
| Maximum | 508 |
| Range | 508 |
| Interquartile range (IQR) | 40 |
Descriptive statistics
| Standard deviation | 35.25534416 |
|---|---|
| Coefficient of variation (CV) | 0.3474555677 |
| Kurtosis | 7.362280019 |
| Mean | 101.4672017 |
| Median Absolute Deviation (MAD) | 19 |
| Skewness | 1.833430443 |
| Sum | 8509141 |
| Variance | 1242.939292 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 110 | 6414 | 7.6% |
| 103 | 4459 | 5.3% |
| 77 | 4323 | 5.2% |
| 81 | 4255 | 5.1% |
| 85 | 4071 | 4.9% |
| 55 | 3769 | 4.5% |
| 100 | 3607 | 4.3% |
| 140 | 3305 | 3.9% |
| 66 | 3156 | 3.8% |
| 96 | 3122 | 3.7% |
| Other values (188) | 43380 |
| Value | Count | Frequency (%) |
| 0 | 38 | < 0.1% |
| 40 | 57 | 0.1% |
| 41 | 10 | < 0.1% |
| 43 | 2 | < 0.1% |
| 44 | 231 |
| Value | Count | Frequency (%) |
| 508 | 1 | < 0.1% |
| 451 | 3 | < 0.1% |
| 449 | 13 | |
| 430 | 2 | < 0.1% |
| 405 | 1 | < 0.1% |
| Distinct | 695 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2199.739104 |
|---|---|
| Minimum | 0 |
| Maximum | 7000 |
| Zeros | 1980 |
| Zeros (%) | 2.4% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1550 |
| Q1 | 1885 |
| median | 2090 |
| Q3 | 2390 |
| 95-th percentile | 3500 |
| Maximum | 7000 |
| Range | 7000 |
| Interquartile range (IQR) | 505 |
Descriptive statistics
| Standard deviation | 649.801155 |
|---|---|
| Coefficient of variation (CV) | 0.2953991925 |
| Kurtosis | 4.009477591 |
| Mean | 2199.739104 |
| Median Absolute Deviation (MAD) | 230 |
| Skewness | 0.2100873553 |
| Sum | 184472321 |
| Variance | 422241.5411 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 3500 | 5388 | 6.4% |
| 1900 | 2450 | 2.9% |
| 0 | 1980 | 2.4% |
| 2100 | 1548 | 1.8% |
| 2800 | 1288 | 1.5% |
| 1675 | 1169 | 1.4% |
| 2020 | 1045 | 1.2% |
| 1850 | 1032 | 1.2% |
| 1940 | 986 | 1.2% |
| 1805 | 962 | 1.1% |
| Other values (685) | 66013 |
| Value | Count | Frequency (%) |
| 0 | 1980 | |
| 980 | 2 | < 0.1% |
| 1020 | 5 | < 0.1% |
| 1050 | 5 | < 0.1% |
| 1150 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 7000 | 21 | < 0.1% |
| 5500 | 5 | < 0.1% |
| 5200 | 152 | |
| 5000 | 109 | |
| 4700 | 6 | < 0.1% |
| Distinct | 1243 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1435.224336 |
|---|---|
| Minimum | 0 |
| Maximum | 3011 |
| Zeros | 5642 |
| Zeros (%) | 6.7% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1302 |
| median | 1475 |
| Q3 | 1699 |
| 95-th percentile | 2045 |
| Maximum | 3011 |
| Range | 3011 |
| Interquartile range (IQR) | 397 |
Descriptive statistics
| Standard deviation | 477.831333 |
|---|---|
| Coefficient of variation (CV) | 0.3329314597 |
| Kurtosis | 3.238187863 |
| Mean | 1435.224336 |
| Median Absolute Deviation (MAD) | 195 |
| Skewness | -1.437748204 |
| Sum | 120359348 |
| Variance | 228322.7828 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5642 | 6.7% |
| 1320 | 1735 | 2.1% |
| 1420 | 1549 | 1.8% |
| 1280 | 1482 | 1.8% |
| 1160 | 1217 | 1.5% |
| 1430 | 1216 | 1.5% |
| 1660 | 857 | 1.0% |
| 1845 | 822 | 1.0% |
| 1370 | 784 | 0.9% |
| 1540 | 727 | 0.9% |
| Other values (1233) | 67830 |
| Value | Count | Frequency (%) |
| 0 | 5642 | |
| 605 | 1 | < 0.1% |
| 720 | 2 | < 0.1% |
| 750 | 3 | < 0.1% |
| 770 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 3011 | 30 | |
| 2984 | 21 | |
| 2832 | 2 | < 0.1% |
| 2783 | 1 | < 0.1% |
| 2766 | 4 | < 0.1% |
| Distinct | 255 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 125.8197493 |
|---|---|
| Minimum | 0 |
| Maximum | 999 |
| Zeros | 3992 |
| Zeros (%) | 4.8% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 32 |
| Q1 | 107 |
| median | 120 |
| Q3 | 149 |
| 95-th percentile | 209 |
| Maximum | 999 |
| Range | 999 |
| Interquartile range (IQR) | 42 |
Descriptive statistics
| Standard deviation | 47.26872164 |
|---|---|
| Coefficient of variation (CV) | 0.3756860261 |
| Kurtosis | 2.978972358 |
| Mean | 125.8197493 |
| Median Absolute Deviation (MAD) | 18 |
| Skewness | -0.1469358058 |
| Sum | 10551370 |
| Variance | 2234.332045 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 119 | 5454 | 6.5% |
| 109 | 4044 | 4.8% |
| 0 | 3992 | 4.8% |
| 99 | 3643 | 4.3% |
| 120 | 2401 | 2.9% |
| 129 | 2250 | 2.7% |
| 139 | 1882 | 2.2% |
| 114 | 1865 | 2.2% |
| 112 | 1827 | 2.2% |
| 104 | 1262 | 1.5% |
| Other values (245) | 55241 |
| Value | Count | Frequency (%) |
| 0 | 3992 | |
| 1 | 16 | < 0.1% |
| 12 | 3 | < 0.1% |
| 13 | 26 | < 0.1% |
| 14 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 999 | 1 | < 0.1% |
| 348 | 2 | < 0.1% |
| 343 | 13 | |
| 340 | 13 | |
| 327 | 9 |
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.823064356 |
|---|---|
| Minimum | 0 |
| Maximum | 12 |
| Zeros | 3673 |
| Zeros (%) | 4.4% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 4 |
| Q3 | 4 |
| 95-th percentile | 4 |
| Maximum | 12 |
| Range | 12 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.8994037623 |
|---|---|
| Coefficient of variation (CV) | 0.2352572906 |
| Kurtosis | 12.39768167 |
| Mean | 3.823064356 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -3.049042464 |
| Sum | 320606 |
| Variance | 0.8089271276 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 73972 | |
| 3 | 3984 | 4.8% |
| 0 | 3673 | 4.4% |
| 6 | 1538 | 1.8% |
| 5 | 622 | 0.7% |
| 8 | 44 | 0.1% |
| 2 | 26 | < 0.1% |
| 12 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 3673 | 4.4% |
| 2 | 26 | < 0.1% |
| 3 | 3984 | 4.8% |
| 4 | 73972 | |
| 5 | 622 | 0.7% |
| Value | Count | Frequency (%) |
| 12 | 2 | < 0.1% |
| 8 | 44 | 0.1% |
| 6 | 1538 | 1.8% |
| 5 | 622 | 0.7% |
| 4 | 73972 |
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.464113235 |
|---|---|
| Minimum | -6 |
| Maximum | 9 |
| Zeros | 20982 |
| Zeros (%) | 25.0% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | -6 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 5 |
| Q3 | 5 |
| 95-th percentile | 5 |
| Maximum | 9 |
| Range | 15 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 2.1046983 |
|---|---|
| Coefficient of variation (CV) | 0.607572027 |
| Kurtosis | -0.9636696509 |
| Mean | 3.464113235 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.9149164142 |
| Sum | 290504 |
| Variance | 4.429754934 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 46549 | |
| 0 | 20982 | |
| 4 | 11246 | 13.4% |
| 3 | 2576 | 3.1% |
| 2 | 2480 | 3.0% |
| 6 | 20 | < 0.1% |
| -6 | 7 | < 0.1% |
| 9 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| -6 | 7 | < 0.1% |
| 0 | 20982 | |
| 2 | 2480 | 3.0% |
| 3 | 2576 | 3.1% |
| 4 | 11246 |
| Value | Count | Frequency (%) |
| 9 | 1 | < 0.1% |
| 6 | 20 | < 0.1% |
| 5 | 46549 | |
| 4 | 11246 | 13.4% |
| 3 | 2576 | 3.1% |
contract_duration
Real number (ℝ≥0)
| Distinct | 66 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35.86346454 |
|---|---|
| Minimum | 1 |
| Maximum | 92 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 24 |
| median | 36 |
| Q3 | 48 |
| 95-th percentile | 60 |
| Maximum | 92 |
| Range | 91 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 15.11114979 |
|---|---|
| Coefficient of variation (CV) | 0.4213522029 |
| Kurtosis | -0.5077759514 |
| Mean | 35.86346454 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | -0.366571452 |
| Sum | 3007546 |
| Variance | 228.3468479 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 36 | 28519 | |
| 48 | 23229 | |
| 12 | 11934 | |
| 60 | 6886 | 8.2% |
| 24 | 6296 | 7.5% |
| 6 | 3431 | 4.1% |
| 42 | 522 | 0.6% |
| 30 | 382 | 0.5% |
| 54 | 185 | 0.2% |
| 40 | 180 | 0.2% |
| Other values (56) | 2297 | 2.7% |
| Value | Count | Frequency (%) |
| 1 | 31 | |
| 2 | 10 | < 0.1% |
| 3 | 5 | < 0.1% |
| 4 | 7 | < 0.1% |
| 5 | 15 |
| Value | Count | Frequency (%) |
| 92 | 1 | < 0.1% |
| 91 | 1 | < 0.1% |
| 84 | 176 | |
| 72 | 82 | |
| 69 | 1 | < 0.1% |
contract_mileage
Real number (ℝ≥0)
| Distinct | 16481 |
|---|---|
| Distinct (%) | 19.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54619.83407 |
|---|---|
| Minimum | 500 |
| Maximum | 270000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | 500 |
|---|---|
| 5-th percentile | 8000 |
| Q1 | 25000 |
| median | 52500 |
| Q3 | 80000 |
| 95-th percentile | 120000 |
| Maximum | 270000 |
| Range | 269500 |
| Interquartile range (IQR) | 55000 |
Descriptive statistics
| Standard deviation | 34811.06138 |
|---|---|
| Coefficient of variation (CV) | 0.637333708 |
| Kurtosis | 0.1301257559 |
| Mean | 54619.83407 |
| Median Absolute Deviation (MAD) | 27500 |
| Skewness | 0.6108718211 |
| Sum | 4580473905 |
| Variance | 1211809994 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 60000 | 6943 | 8.3% |
| 80000 | 5019 | 6.0% |
| 30000 | 3678 | 4.4% |
| 10000 | 3214 | 3.8% |
| 75000 | 3053 | 3.6% |
| 100000 | 2484 | 3.0% |
| 90000 | 2416 | 2.9% |
| 40000 | 2086 | 2.5% |
| 20000 | 2039 | 2.4% |
| 45000 | 2033 | 2.4% |
| Other values (16471) | 50896 |
| Value | Count | Frequency (%) |
| 500 | 2 | |
| 750 | 1 | |
| 756 | 1 | |
| 896 | 1 | |
| 972 | 1 |
| Value | Count | Frequency (%) |
| 270000 | 2 | < 0.1% |
| 250000 | 2 | < 0.1% |
| 212895 | 1 | < 0.1% |
| 201785 | 1 | < 0.1% |
| 200000 | 7 |
monthly_lease_installment
Real number (ℝ)
| Distinct | 39553 |
|---|---|
| Distinct (%) | 47.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 360.0503313 |
|---|---|
| Minimum | -500.07 |
| Maximum | 2891.8 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | -500.07 |
|---|---|
| 5-th percentile | 137.22 |
| Q1 | 254.77 |
| median | 338.79 |
| Q3 | 448.11 |
| 95-th percentile | 626.31 |
| Maximum | 2891.8 |
| Range | 3391.87 |
| Interquartile range (IQR) | 193.34 |
Descriptive statistics
| Standard deviation | 156.7400635 |
|---|---|
| Coefficient of variation (CV) | 0.4353282026 |
| Kurtosis | 5.711772439 |
| Mean | 360.0503313 |
| Median Absolute Deviation (MAD) | 94.86 |
| Skewness | 1.298408366 |
| Sum | 30194180.83 |
| Variance | 24567.44752 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 294.2 | 159 | 0.2% |
| 321.34 | 121 | 0.1% |
| 310.46 | 105 | 0.1% |
| 174.73 | 60 | 0.1% |
| 514.76 | 57 | 0.1% |
| 599.55 | 52 | 0.1% |
| 84.98 | 51 | 0.1% |
| 300.68 | 49 | 0.1% |
| 159.11 | 49 | 0.1% |
| 216.64 | 48 | 0.1% |
| Other values (39543) | 83110 |
| Value | Count | Frequency (%) |
| -500.07 | 1 | |
| 0 | 1 | |
| 1 | 2 | |
| 11.49 | 1 | |
| 15.85 | 1 |
| Value | Count | Frequency (%) |
| 2891.8 | 1 | |
| 2086.96 | 1 | |
| 2058.34 | 1 | |
| 2031.64 | 1 | |
| 2009.53 | 1 |
| Distinct | 2101 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.492942607 |
|---|---|
| Minimum | -2 |
| Maximum | 57.97 |
| Zeros | 44032 |
| Zeros (%) | 52.5% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | -2 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 10.25 |
| 95-th percentile | 19 |
| Maximum | 57.97 |
| Range | 59.97 |
| Interquartile range (IQR) | 10.25 |
Descriptive statistics
| Standard deviation | 8.26226607 |
|---|---|
| Coefficient of variation (CV) | 1.504160276 |
| Kurtosis | 6.624982316 |
| Mean | 5.492942607 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.253848121 |
| Sum | 460643.66 |
| Variance | 68.26504062 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 44032 | |
| 12 | 3320 | 4.0% |
| 11 | 3246 | 3.9% |
| 10 | 2772 | 3.3% |
| 14 | 2545 | 3.0% |
| 8 | 1869 | 2.2% |
| 2.5 | 1756 | 2.1% |
| 9 | 1614 | 1.9% |
| 3 | 1519 | 1.8% |
| 10.5 | 1455 | 1.7% |
| Other values (2091) | 19733 |
| Value | Count | Frequency (%) |
| -2 | 8 | < 0.1% |
| -0.4 | 1 | < 0.1% |
| -0.23 | 1 | < 0.1% |
| -0.08 | 1 | < 0.1% |
| 0 | 44032 |
| Value | Count | Frequency (%) |
| 57.97 | 1 | < 0.1% |
| 56.28 | 1 | < 0.1% |
| 55.59 | 6 | |
| 55.57 | 1 | < 0.1% |
| 55.55 | 2 | < 0.1% |
| Distinct | 32394 |
|---|---|
| Distinct (%) | 38.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4037.132729 |
|---|---|
| Minimum | 0 |
| Maximum | 19007.49 |
| Zeros | 17539 |
| Zeros (%) | 20.9% |
| Memory size | 655.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1646.26 |
| median | 3825.26 |
| Q3 | 5871.29 |
| 95-th percentile | 9964.85 |
| Maximum | 19007.49 |
| Range | 19007.49 |
| Interquartile range (IQR) | 4225.03 |
Descriptive statistics
| Standard deviation | 3214.28036 |
|---|---|
| Coefficient of variation (CV) | 0.7961790152 |
| Kurtosis | 0.4251740871 |
| Mean | 4037.132729 |
| Median Absolute Deviation (MAD) | 2103.26 |
| Skewness | 0.7107629435 |
| Sum | 338557987.8 |
| Variance | 10331598.23 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 17539 | 20.9% |
| 6788.35 | 256 | 0.3% |
| 7342.03 | 246 | 0.3% |
| 4458.37 | 170 | 0.2% |
| 5805.81 | 148 | 0.2% |
| 8345.83 | 124 | 0.1% |
| 3500 | 123 | 0.1% |
| 12476.15 | 116 | 0.1% |
| 4278.56 | 114 | 0.1% |
| 8673.33 | 103 | 0.1% |
| Other values (32384) | 64922 |
| Value | Count | Frequency (%) |
| 0 | 17539 | |
| 30.41 | 1 | < 0.1% |
| 56.83 | 1 | < 0.1% |
| 56.84 | 1 | < 0.1% |
| 62.19 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 19007.49 | 1 | < 0.1% |
| 18574.58 | 1 | < 0.1% |
| 18039 | 4 | < 0.1% |
| 16860.6 | 16 | |
| 16800 | 1 | < 0.1% |
| Distinct | 44 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| Ford | |
|---|---|
| Bmw | |
| Volkswagen | |
| Opel | |
| Audi | |
| Other values (39) |
Length
| Max length | 10 |
|---|---|
| Median length | 5 |
| Mean length | 5.669679589 |
| Min length | 2 |
Characters and Unicode
| Total characters | 475465 |
|---|---|
| Distinct characters | 43 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Peugeot |
|---|---|
| 2nd row | Peugeot |
| 3rd row | Bmw |
| 4th row | Bmw |
| 5th row | Nissan |
| Value | Count | Frequency (%) |
| Ford | 13637 | |
| Bmw | 9572 | |
| Volkswagen | 9123 | |
| Opel | 7609 | |
| Audi | 6681 | 8.0% |
| Mercedes | 6115 | 7.3% |
| Renault | 5138 | 6.1% |
| Toyota | 3222 | 3.8% |
| Nissan | 3029 | 3.6% |
| Peugeot | 3007 | 3.6% |
| Other values (34) | 16728 |
| Value | Count | Frequency (%) |
| ford | 13637 | |
| bmw | 9572 | |
| volkswagen | 9123 | |
| opel | 7609 | |
| audi | 6681 | 7.8% |
| mercedes | 6115 | 7.1% |
| renault | 5138 | 6.0% |
| toyota | 3222 | 3.8% |
| nissan | 3029 | 3.5% |
| peugeot | 3007 | 3.5% |
| Other values (36) | 18477 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 53246 | 11.2% |
| o | 43529 | 9.2% |
| a | 31610 | 6.6% |
| d | 31603 | 6.6% |
| r | 24641 | 5.2% |
| l | 24552 | 5.2% |
| s | 24228 | 5.1% |
| n | 23111 | 4.9% |
| w | 18695 | 3.9% |
| i | 18467 | 3.9% |
| Other values (33) | 181783 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 388106 | |
| Uppercase Letter | 85610 | 18.0% |
| Space Separator | 1749 | 0.4% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 53246 | |
| o | 43529 | |
| a | 31610 | 8.1% |
| d | 31603 | 8.1% |
| r | 24641 | 6.3% |
| l | 24552 | 6.3% |
| s | 24228 | 6.2% |
| n | 23111 | 6.0% |
| w | 18695 | 4.8% |
| i | 18467 | 4.8% |
| Other values (14) | 94424 |
| Value | Count | Frequency (%) |
| F | 14015 | |
| V | 11345 | |
| B | 9572 | |
| M | 8745 | |
| O | 7609 | |
| A | 6902 | |
| R | 6887 | |
| S | 3441 | 4.0% |
| T | 3440 | 4.0% |
| P | 3045 | 3.6% |
| Other values (8) | 10609 |
| Value | Count | Frequency (%) |
| 1749 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 473716 | |
| Common | 1749 | 0.4% |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 53246 | 11.2% |
| o | 43529 | 9.2% |
| a | 31610 | 6.7% |
| d | 31603 | 6.7% |
| r | 24641 | 5.2% |
| l | 24552 | 5.2% |
| s | 24228 | 5.1% |
| n | 23111 | 4.9% |
| w | 18695 | 3.9% |
| i | 18467 | 3.9% |
| Other values (32) | 180034 |
| Value | Count | Frequency (%) |
| 1749 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 475465 |
Most frequent character per block
| Value | Count | Frequency (%) |
| e | 53246 | 11.2% |
| o | 43529 | 9.2% |
| a | 31610 | 6.6% |
| d | 31603 | 6.6% |
| r | 24641 | 5.2% |
| l | 24552 | 5.2% |
| s | 24228 | 5.1% |
| n | 23111 | 4.9% |
| w | 18695 | 3.9% |
| i | 18467 | 3.9% |
| Other values (33) | 181783 |
| Distinct | 425 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| Transit | 3858 |
|---|---|
| Series 3 | 3800 |
| Golf | 3725 |
| Focus | 2554 |
| A3 | 2241 |
| Other values (420) |
Length
| Max length | 22 |
|---|---|
| Median length | 6 |
| Mean length | 6.278675427 |
| Min length | 1 |
Characters and Unicode
| Total characters | 526536 |
|---|---|
| Distinct characters | 65 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 45 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Bipper |
|---|---|
| 2nd row | Bipper |
| 3rd row | Series 4 |
| 4th row | Series 4 |
| 5th row | Np300 Navara |
| Value | Count | Frequency (%) |
| Transit | 3858 | 4.6% |
| Series 3 | 3800 | 4.5% |
| Golf | 3725 | 4.4% |
| Focus | 2554 | 3.0% |
| A3 | 2241 | 2.7% |
| Passat | 2139 | 2.6% |
| Corsa | 2130 | 2.5% |
| Transit Custom | 2123 | 2.5% |
| Series 5 | 2011 | 2.4% |
| A4 | 1869 | 2.2% |
| Other values (415) | 57411 |
| Value | Count | Frequency (%) |
| series | 8213 | 8.2% |
| transit | 7651 | 7.6% |
| 3 | 3930 | 3.9% |
| golf | 3756 | 3.7% |
| focus | 2554 | 2.5% |
| passat | 2479 | 2.5% |
| a3 | 2241 | 2.2% |
| corsa | 2130 | 2.1% |
| custom | 2123 | 2.1% |
| 5 | 2016 | 2.0% |
| Other values (405) | 63114 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 49555 | 9.4% |
| s | 48843 | 9.3% |
| r | 40856 | 7.8% |
| e | 39273 | 7.5% |
| i | 35030 | 6.7% |
| o | 30370 | 5.8% |
| n | 27690 | 5.3% |
| t | 26615 | 5.1% |
| C | 16783 | 3.2% |
| 16346 | 3.1% | |
| Other values (55) | 195175 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 377676 | |
| Uppercase Letter | 96028 | 18.2% |
| Decimal Number | 30229 | 5.7% |
| Space Separator | 16346 | 3.1% |
| Dash Punctuation | 6085 | 1.2% |
| Math Symbol | 172 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| C | 16783 | |
| S | 11858 | |
| T | 11641 | |
| A | 10377 | |
| M | 5316 | 5.5% |
| G | 5121 | 5.3% |
| P | 4804 | 5.0% |
| F | 4388 | 4.6% |
| R | 3482 | 3.6% |
| X | 3342 | 3.5% |
| Other values (16) | 18916 |
| Value | Count | Frequency (%) |
| a | 49555 | |
| s | 48843 | |
| r | 40856 | |
| e | 39273 | |
| i | 35030 | |
| o | 30370 | |
| n | 27690 | |
| t | 26615 | |
| l | 13872 | 3.7% |
| c | 11468 | 3.0% |
| Other values (16) | 54104 |
| Value | Count | Frequency (%) |
| 3 | 7920 | |
| 0 | 5847 | |
| 5 | 4157 | |
| 4 | 3596 | |
| 1 | 2471 | 8.2% |
| 6 | 2382 | 7.9% |
| 2 | 1955 | 6.5% |
| 8 | 1221 | 4.0% |
| 7 | 448 | 1.5% |
| 9 | 232 | 0.8% |
| Value | Count | Frequency (%) |
| 16346 |
| Value | Count | Frequency (%) |
| - | 6085 |
| Value | Count | Frequency (%) |
| + | 172 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 473704 | |
| Common | 52832 | 10.0% |
Most frequent character per script
| Value | Count | Frequency (%) |
| a | 49555 | 10.5% |
| s | 48843 | 10.3% |
| r | 40856 | 8.6% |
| e | 39273 | 8.3% |
| i | 35030 | 7.4% |
| o | 30370 | 6.4% |
| n | 27690 | 5.8% |
| t | 26615 | 5.6% |
| C | 16783 | 3.5% |
| l | 13872 | 2.9% |
| Other values (42) | 144817 |
| Value | Count | Frequency (%) |
| 16346 | ||
| 3 | 7920 | |
| - | 6085 | 11.5% |
| 0 | 5847 | 11.1% |
| 5 | 4157 | 7.9% |
| 4 | 3596 | 6.8% |
| 1 | 2471 | 4.7% |
| 6 | 2382 | 4.5% |
| 2 | 1955 | 3.7% |
| 8 | 1221 | 2.3% |
| Other values (3) | 852 | 1.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 526536 |
Most frequent character per block
| Value | Count | Frequency (%) |
| a | 49555 | 9.4% |
| s | 48843 | 9.3% |
| r | 40856 | 7.8% |
| e | 39273 | 7.5% |
| i | 35030 | 6.7% |
| o | 30370 | 5.8% |
| n | 27690 | 5.3% |
| t | 26615 | 5.1% |
| C | 16783 | 3.2% |
| 16346 | 3.1% | |
| Other values (55) | 195175 |
enriched_primary_fuel_type
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| Diesel | |
|---|---|
| Unleaded | |
| Electric | 3393 |
| Premium Unleaded | 2323 |
| E85 | 7 |
Length
| Max length | 16 |
|---|---|
| Median length | 6 |
| Mean length | 6.585027605 |
| Min length | 3 |
Characters and Unicode
| Total characters | 552227 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Diesel |
|---|---|
| 2nd row | Diesel |
| 3rd row | Diesel |
| 4th row | Diesel |
| 5th row | Diesel |
| Value | Count | Frequency (%) |
| Diesel | 68605 | |
| Unleaded | 9533 | 11.4% |
| Electric | 3393 | 4.0% |
| Premium Unleaded | 2323 | 2.8% |
| E85 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| diesel | 68605 | |
| unleaded | 11856 | 13.8% |
| electric | 3393 | 3.9% |
| premium | 2323 | 2.7% |
| e85 | 7 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 166638 | |
| l | 83854 | |
| i | 74321 | |
| D | 68605 | |
| s | 68605 | |
| d | 23712 | 4.3% |
| U | 11856 | 2.1% |
| n | 11856 | 2.1% |
| a | 11856 | 2.1% |
| c | 6786 | 1.2% |
| Other values (9) | 24138 | 4.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 463706 | |
| Uppercase Letter | 86184 | 15.6% |
| Space Separator | 2323 | 0.4% |
| Decimal Number | 14 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 166638 | |
| l | 83854 | |
| i | 74321 | |
| s | 68605 | |
| d | 23712 | 5.1% |
| n | 11856 | 2.6% |
| a | 11856 | 2.6% |
| c | 6786 | 1.5% |
| r | 5716 | 1.2% |
| m | 4646 | 1.0% |
| Other values (2) | 5716 | 1.2% |
| Value | Count | Frequency (%) |
| D | 68605 | |
| U | 11856 | 13.8% |
| E | 3400 | 3.9% |
| P | 2323 | 2.7% |
| Value | Count | Frequency (%) |
| 8 | 7 | |
| 5 | 7 |
| Value | Count | Frequency (%) |
| 2323 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 549890 | |
| Common | 2337 | 0.4% |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 166638 | |
| l | 83854 | |
| i | 74321 | |
| D | 68605 | |
| s | 68605 | |
| d | 23712 | 4.3% |
| U | 11856 | 2.2% |
| n | 11856 | 2.2% |
| a | 11856 | 2.2% |
| c | 6786 | 1.2% |
| Other values (6) | 21801 | 4.0% |
| Value | Count | Frequency (%) |
| 2323 | ||
| 8 | 7 | 0.3% |
| 5 | 7 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 552227 |
Most frequent character per block
| Value | Count | Frequency (%) |
| e | 166638 | |
| l | 83854 | |
| i | 74321 | |
| D | 68605 | |
| s | 68605 | |
| d | 23712 | 4.3% |
| U | 11856 | 2.1% |
| n | 11856 | 2.1% |
| a | 11856 | 2.1% |
| c | 6786 | 1.2% |
| Other values (9) | 24138 | 4.4% |
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| Lower Medium | |
|---|---|
| Upper Medium | |
| SUV | |
| Medium Commercial | |
| Small Commercial | |
| Other values (12) |
Length
| Max length | 22 |
|---|---|
| Median length | 12 |
| Mean length | 11.43647226 |
| Min length | 3 |
Characters and Unicode
| Total characters | 959074 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Car Derived Commercial |
|---|---|
| 2nd row | Car Derived Commercial |
| 3rd row | Sports |
| 4th row | Sports |
| 5th row | Pickup |
| Value | Count | Frequency (%) |
| Lower Medium | 18174 | |
| Upper Medium | 17255 | |
| SUV | 9171 | |
| Medium Commercial | 8333 | |
| Small Commercial | 7304 | |
| Small | 6343 | 7.6% |
| Car Derived Commercial | 5663 | 6.8% |
| Executive | 4393 | 5.2% |
| Mini MPV | 1948 | 2.3% |
| Sports | 1668 | 2.0% |
| Other values (7) | 3609 | 4.3% |
| Value | Count | Frequency (%) |
| medium | 44432 | |
| commercial | 21300 | |
| lower | 18191 | |
| upper | 17275 | 11.5% |
| small | 13647 | 9.1% |
| suv | 9208 | 6.1% |
| car | 5663 | 3.8% |
| derived | 5663 | 3.8% |
| executive | 4393 | 2.9% |
| mpv | 3069 | 2.0% |
| Other values (6) | 7043 | 4.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 121798 | |
| m | 100679 | 10.5% |
| i | 83340 | 8.7% |
| r | 69800 | 7.3% |
| 66023 | 6.9% | |
| u | 51047 | 5.3% |
| M | 50206 | 5.2% |
| d | 50095 | 5.2% |
| l | 49570 | 5.2% |
| o | 41159 | 4.3% |
| Other values (21) | 275357 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 718613 | |
| Uppercase Letter | 174438 | 18.2% |
| Space Separator | 66023 | 6.9% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 121798 | |
| m | 100679 | |
| i | 83340 | |
| r | 69800 | |
| u | 51047 | |
| d | 50095 | |
| l | 49570 | |
| o | 41159 | 5.7% |
| a | 40610 | 5.7% |
| p | 37872 | 5.3% |
| Other values (10) | 72643 |
| Value | Count | Frequency (%) |
| M | 50206 | |
| C | 26963 | |
| U | 26483 | |
| S | 25011 | |
| L | 18231 | 10.5% |
| V | 12277 | 7.0% |
| D | 5663 | 3.2% |
| P | 4723 | 2.7% |
| E | 4393 | 2.5% |
| F | 488 | 0.3% |
| Value | Count | Frequency (%) |
| 66023 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 893051 | |
| Common | 66023 | 6.9% |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 121798 | |
| m | 100679 | |
| i | 83340 | 9.3% |
| r | 69800 | 7.8% |
| u | 51047 | 5.7% |
| M | 50206 | 5.6% |
| d | 50095 | 5.6% |
| l | 49570 | 5.6% |
| o | 41159 | 4.6% |
| a | 40610 | 4.5% |
| Other values (20) | 234747 |
| Value | Count | Frequency (%) |
| 66023 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 959074 |
Most frequent character per block
| Value | Count | Frequency (%) |
| e | 121798 | |
| m | 100679 | 10.5% |
| i | 83340 | 8.7% |
| r | 69800 | 7.3% |
| 66023 | 6.9% | |
| u | 51047 | 5.3% |
| M | 50206 | 5.2% |
| d | 50095 | 5.2% |
| l | 49570 | 5.2% |
| o | 41159 | 4.3% |
| Other values (21) | 275357 |
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| C1 - lower medium - | |
|---|---|
| D2 - upper medium + | |
| Medium Commercial | |
| C2 - lower medium + | |
| Medium SUV | |
| Other values (19) |
Length
| Max length | 24 |
|---|---|
| Median length | 17 |
| Mean length | 15.88322343 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1331983 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Car Derived Van |
|---|---|
| 2nd row | Car Derived Van |
| 3rd row | Sports |
| 4th row | Sports |
| 5th row | Pickup |
| Value | Count | Frequency (%) |
| C1 - lower medium - | 11121 | |
| D2 - upper medium + | 9288 | |
| Medium Commercial | 8333 | |
| C2 - lower medium + | 8205 | |
| Medium SUV | 7605 | |
| D1 - upper medium - | 6828 | |
| Small Commercial | 6738 | |
| B - small | 6303 | |
| Car Derived Van | 5660 | |
| E1 - large and executive | 4393 | 5.2% |
| Other values (14) | 9387 |
| Value | Count | Frequency (%) |
| 82416 | ||
| medium | 52013 | |
| lower | 19326 | 6.5% |
| upper | 16116 | 5.4% |
| commercial | 15627 | 5.3% |
| small | 13810 | 4.6% |
| c1 | 11124 | 3.7% |
| suv | 9704 | 3.3% |
| d2 | 9300 | 3.1% |
| c2 | 8205 | 2.8% |
| Other values (18) | 59798 |
Most occurring characters
| Value | Count | Frequency (%) |
| 213578 | ||
| e | 132572 | 10.0% |
| m | 132519 | 9.9% |
| i | 85705 | 6.4% |
| u | 76410 | 5.7% |
| r | 70513 | 5.3% |
| l | 67802 | 5.1% |
| - | 64923 | 4.9% |
| d | 62066 | 4.7% |
| a | 50937 | 3.8% |
| Other values (27) | 374958 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 846725 | |
| Space Separator | 213578 | 16.0% |
| Uppercase Letter | 148571 | 11.2% |
| Dash Punctuation | 64923 | 4.9% |
| Decimal Number | 39897 | 3.0% |
| Math Symbol | 17493 | 1.3% |
| Other Punctuation | 796 | 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 132572 | |
| m | 132519 | |
| i | 85705 | |
| u | 76410 | |
| r | 70513 | |
| l | 67802 | |
| d | 62066 | |
| a | 50937 | 6.0% |
| o | 36608 | 4.3% |
| p | 35615 | 4.2% |
| Other values (10) | 95978 |
| Value | Count | Frequency (%) |
| C | 40616 | |
| D | 21795 | |
| M | 21588 | |
| S | 18866 | |
| V | 18433 | |
| U | 9704 | 6.5% |
| B | 6303 | 4.2% |
| P | 4797 | 3.2% |
| E | 4433 | 3.0% |
| L | 1240 | 0.8% |
| Value | Count | Frequency (%) |
| 1 | 22352 | |
| 2 | 17545 |
| Value | Count | Frequency (%) |
| 213578 |
| Value | Count | Frequency (%) |
| - | 64923 |
| Value | Count | Frequency (%) |
| / | 796 |
| Value | Count | Frequency (%) |
| + | 17493 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 995296 | |
| Common | 336687 | 25.3% |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 132572 | |
| m | 132519 | |
| i | 85705 | 8.6% |
| u | 76410 | 7.7% |
| r | 70513 | 7.1% |
| l | 67802 | 6.8% |
| d | 62066 | 6.2% |
| a | 50937 | 5.1% |
| C | 40616 | 4.1% |
| o | 36608 | 3.7% |
| Other values (21) | 239548 |
| Value | Count | Frequency (%) |
| 213578 | ||
| - | 64923 | 19.3% |
| 1 | 22352 | 6.6% |
| 2 | 17545 | 5.2% |
| + | 17493 | 5.2% |
| / | 796 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1331983 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 213578 | ||
| e | 132572 | 10.0% |
| m | 132519 | 9.9% |
| i | 85705 | 6.4% |
| u | 76410 | 5.7% |
| r | 70513 | 5.3% |
| l | 67802 | 5.1% |
| - | 64923 | 4.9% |
| d | 62066 | 4.7% |
| a | 50937 | 3.8% |
| Other values (27) | 374958 |
new_powertrain_type
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| combustion | |
|---|---|
| phev | 2456 |
| hev | 2005 |
| bev | 911 |
| mhev | 206 |
Length
| Max length | 15 |
|---|---|
| Median length | 10 |
| Mean length | 9.566198829 |
| Min length | 3 |
Characters and Unicode
| Total characters | 802231 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | combustion |
|---|---|
| 2nd row | combustion |
| 3rd row | combustion |
| 4th row | combustion |
| 5th row | combustion |
| Value | Count | Frequency (%) |
| combustion | 78282 | |
| phev | 2456 | 2.9% |
| hev | 2005 | 2.4% |
| bev | 911 | 1.1% |
| mhev | 206 | 0.2% |
| alternate fuels | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| combustion | 78282 | |
| phev | 2456 | 2.9% |
| hev | 2005 | 2.4% |
| bev | 911 | 1.1% |
| mhev | 206 | 0.2% |
| alternate | 1 | < 0.1% |
| fuels | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 156564 | |
| b | 79193 | |
| m | 78488 | |
| t | 78284 | |
| u | 78283 | |
| s | 78283 | |
| n | 78283 | |
| c | 78282 | |
| i | 78282 | |
| e | 5581 | 0.7% |
| Other values (8) | 12708 | 1.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 802230 | |
| Space Separator | 1 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| o | 156564 | |
| b | 79193 | |
| m | 78488 | |
| t | 78284 | |
| u | 78283 | |
| s | 78283 | |
| n | 78283 | |
| c | 78282 | |
| i | 78282 | |
| e | 5581 | 0.7% |
| Other values (7) | 12707 | 1.6% |
| Value | Count | Frequency (%) |
| 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 802230 | |
| Common | 1 | < 0.1% |
Most frequent character per script
| Value | Count | Frequency (%) |
| o | 156564 | |
| b | 79193 | |
| m | 78488 | |
| t | 78284 | |
| u | 78283 | |
| s | 78283 | |
| n | 78283 | |
| c | 78282 | |
| i | 78282 | |
| e | 5581 | 0.7% |
| Other values (7) | 12707 | 1.6% |
| Value | Count | Frequency (%) |
| 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 802231 |
Most frequent character per block
| Value | Count | Frequency (%) |
| o | 156564 | |
| b | 79193 | |
| m | 78488 | |
| t | 78284 | |
| u | 78283 | |
| s | 78283 | |
| n | 78283 | |
| c | 78282 | |
| i | 78282 | |
| e | 5581 | 0.7% |
| Other values (8) | 12708 | 1.6% |
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 655.3 KiB |
| Corporate | |
|---|---|
| Small fleet | |
| Governments | |
| Private Households | |
| Insurance companies | 3608 |
| Other values (2) | 90 |
Length
| Max length | 19 |
|---|---|
| Median length | 9 |
| Mean length | 10.80540418 |
| Min length | 5 |
Characters and Unicode
| Total characters | 906152 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Small fleet |
|---|---|
| 2nd row | Small fleet |
| 3rd row | Private Households |
| 4th row | Private Households |
| 5th row | Small fleet |
| Value | Count | Frequency (%) |
| Corporate | 45877 | |
| Small fleet | 20402 | |
| Governments | 7155 | 8.5% |
| Private Households | 6729 | 8.0% |
| Insurance companies | 3608 | 4.3% |
| Banks | 88 | 0.1% |
| Own fleet | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| corporate | 45877 | |
| fleet | 20404 | |
| small | 20402 | |
| governments | 7155 | 6.2% |
| private | 6729 | 5.9% |
| households | 6729 | 5.9% |
| insurance | 3608 | 3.1% |
| companies | 3608 | 3.1% |
| banks | 88 | 0.1% |
| own | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 121669 | |
| o | 115975 | |
| r | 109246 | |
| a | 80312 | |
| t | 80165 | |
| l | 67937 | 7.5% |
| p | 49485 | 5.5% |
| C | 45877 | 5.1% |
| m | 31165 | 3.4% |
| 30741 | 3.4% | |
| Other values (18) | 173580 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 784821 | |
| Uppercase Letter | 90590 | 10.0% |
| Space Separator | 30741 | 3.4% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 121669 | |
| o | 115975 | |
| r | 109246 | |
| a | 80312 | |
| t | 80165 | |
| l | 67937 | |
| p | 49485 | |
| m | 31165 | 4.0% |
| s | 27917 | 3.6% |
| n | 25224 | 3.2% |
| Other values (9) | 75726 |
| Value | Count | Frequency (%) |
| C | 45877 | |
| S | 20402 | |
| G | 7155 | 7.9% |
| P | 6729 | 7.4% |
| H | 6729 | 7.4% |
| I | 3608 | 4.0% |
| B | 88 | 0.1% |
| O | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 30741 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 875411 | |
| Common | 30741 | 3.4% |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 121669 | |
| o | 115975 | |
| r | 109246 | |
| a | 80312 | |
| t | 80165 | |
| l | 67937 | |
| p | 49485 | 5.7% |
| C | 45877 | 5.2% |
| m | 31165 | 3.6% |
| s | 27917 | 3.2% |
| Other values (17) | 145663 |
| Value | Count | Frequency (%) |
| 30741 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 906152 |
Most frequent character per block
| Value | Count | Frequency (%) |
| e | 121669 | |
| o | 115975 | |
| r | 109246 | |
| a | 80312 | |
| t | 80165 | |
| l | 67937 | 7.5% |
| p | 49485 | 5.5% |
| C | 45877 | 5.1% |
| m | 31165 | 3.4% |
| 30741 | 3.4% | |
| Other values (18) | 173580 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| srno | customer_number | customer_id | customer_local_key | branch_desc_cons | business_classification_desc | driver_name | start_date_leasecontract | end_date_leasecontract | leasecontract_status_cons | customer_driver_id | lease_contract_id | leasecontract_number | vehicle_id | vehicle_local_key | make_cons | registration_date | model_cons | model_type_desc | manufacturer_group | vehicle_type_cons | vehicle_segment_desc | primary_fuel_type_cons | fuel_consump_manufacturer | cat_price_euro | cat_price_options_euro | cat_price_accessories_euro | product_name_cons | engine_capacity | engine_power | gross_weight | tare_weight | co2_level_combined | number_of_cylinders | number_of_doors | contract_duration | contract_mileage | monthly_lease_installment | supplier_discount_perc | discount_to_customer | enriched_make | enriched_model | enriched_primary_fuel_type | segment_global | segment_regional | new_powertrain_type | Customer_Segment | Unnamed: 47 | Unnamed: 48 | Unnamed: 49 | Unnamed: 50 | Unnamed: 51 | Unnamed: 52 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1549 | 506550 | 28898981 | UK-C-506550 | Furniture And Fixtures | Small fleet | toby downes | 2014-03-10 00:00:00 | 2018-04-09 00:00:00 | Ended | 00000000000004999185 | 166437943 | 9877167 | 355176170 | UK-9877167 | Peugeot | 2013-12-31 | BIPPER | 1.3D75 PROF | PSA | Van | Car derived van | Diesel | 0.00 | 13580.60 | 0.00 | 118.29 | Full service Closed calculation | 1248 | 55 | 1750 | 1090 | 119 | 4 | 0 | 48 | 40000 | 144.25 | 9.00 | 5526.90 | Peugeot | Bipper | Diesel | Car Derived Commercial | Car Derived Van | combustion | Small fleet | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | 1550 | 506550 | 28898981 | UK-C-506550 | Furniture And Fixtures | Small fleet | toby downes | 2018-04-10 00:00:00 | 2019-04-08 00:00:00 | Ended | 00000000000004999185 | 330880853 | 1177401 | 459686869 | UK-1177401 | Peugeot | 2013-12-31 | BIPPER | 1.3D75 PROF | PSA | Van | Car derived van | Diesel | 0.00 | 13580.60 | 0.00 | 0.00 | Full service Closed calculation | 1248 | 55 | 1750 | 1090 | 119 | 4 | 0 | 12 | 8000 | 137.01 | 0.00 | 0.00 | Peugeot | Bipper | Diesel | Car Derived Commercial | Car Derived Van | combustion | Small fleet | NaN | NaN | NaN | NaN | NaN | NaN |
| 2 | 1553 | 841984 | 32193564 | UK-C-841984 | Private Households | Private Households | thomas fosmes | 2016-04-25 00:00:00 | 2018-05-24 00:00:00 | Ended | 00000000000005174754 | 270272684 | 1051210 | 413736656 | UK-1051210 | BMW | 2016-03-31 | 4 SERIES | 2.0 M SPT PRF A | BMW Group | Car | Medium car | Diesel | 1.56 | 32858.23 | 484.05 | 0.00 | Full service Closed calculation | 1995 | 110 | 2005 | 1485 | 117 | 4 | 2 | 24 | 16000 | 280.24 | 19.00 | 7571.25 | Bmw | Series 4 | Diesel | Sports | Sports | combustion | Private Households | NaN | NaN | NaN | NaN | NaN | NaN |
| 3 | 1554 | 841984 | 32193564 | UK-C-841984 | Private Households | Private Households | thomas fosmes | 2018-05-25 00:00:00 | 2018-10-08 00:00:00 | Ended | 00000000000005174754 | 332866747 | 1183042 | 461405173 | UK-1183042 | BMW | 2016-03-31 | 4 SERIES | 2.0 M SPT PRF A | BMW Group | Car | Medium car | Diesel | 1.56 | 32858.23 | 0.00 | 0.00 | Full service Closed calculation | 1995 | 110 | 2005 | 1485 | 117 | 4 | 2 | 12 | 14000 | 370.74 | 0.00 | 0.00 | Bmw | Series 4 | Diesel | Sports | Sports | combustion | Private Households | NaN | NaN | NaN | NaN | NaN | NaN |
| 4 | 1555 | 850742 | 32852015 | UK-C-850742 | Special Trade Contractors | Small fleet | terry cottam | 2016-09-26 00:00:00 | 2019-09-25 00:00:00 | Ended | 00000000000005210435 | 279071510 | 1083812 | 423903120 | UK-1083812 | Nissan | 2016-07-31 | NP300 | 190 D/C TEKNA A | Renault-Nissan | Van | Other Van | Diesel | 0.00 | 28272.07 | 393.26 | 0.00 | Full service Closed calculation | 2298 | 140 | 3010 | 1958 | 183 | 4 | 0 | 36 | 60000 | 298.40 | 25.08 | 6377.49 | Nissan | Np300 Navara | Diesel | Pickup | Pickup | combustion | Small fleet | NaN | NaN | NaN | NaN | NaN | NaN |
| 5 | 1556 | 850742 | 32852015 | UK-C-850742 | Special Trade Contractors | Small fleet | terry cottam | 2019-09-26 00:00:00 | ############################################################################################################################################################################################################################################################### | Operational | 00000000000005210435 | 369891143 | 1289414 | 487420561 | UK-1289414 | Nissan | 2016-07-31 | NP300 | 190 D/C TEKNA A | Renault-Nissan | Van | Other Van | Diesel | 0.00 | 28272.07 | 0.00 | 0.00 | Full service Closed calculation | 2298 | 140 | 3010 | 1958 | 183 | 4 | 0 | 12 | 20000 | 333.05 | 0.00 | 0.00 | Nissan | Np300 Navara | Diesel | Pickup | Pickup | combustion | Small fleet | NaN | NaN | NaN | NaN | NaN | NaN |
| 6 | 1562 | 814699 | 29954544 | UK-C-814699 | Private Households | Small fleet | terence podmore | 2017-04-21 00:00:00 | 2018-04-12 00:00:00 | Ended | 00000000000005000917 | 298538712 | 1115966 | 438920711 | UK-1115966 | Audi | 2014-03-19 | Q5 | 2.0D177 S-LINE+ | VAG | Car | SUV | Diesel | 0.00 | 33988.55 | 0.00 | 0.00 | Full service Closed calculation | 1968 | 130 | 2365 | 1755 | 154 | 4 | 5 | 12 | 10000 | 353.10 | 0.00 | 0.00 | Audi | Q5 | Diesel | SUV | Medium SUV | combustion | Small fleet | NaN | NaN | NaN | NaN | NaN | NaN |
| 7 | 1563 | 814699 | 29954544 | UK-C-814699 | Private Households | Small fleet | terence podmore | 2014-03-21 00:00:00 | 2017-04-20 00:00:00 | Ended | 00000000000005000917 | 166569096 | 9879025 | 355715224 | UK-9879025 | Audi | 2014-03-19 | Q5 | 2.0D177 S-LINE+ | VAG | Car | SUV | Diesel | 0.00 | 33988.55 | 481.59 | 0.00 | Full service Closed calculation | 1968 | 130 | 2365 | 1755 | 154 | 4 | 5 | 36 | 30000 | 383.64 | 12.00 | 3629.99 | Audi | Q5 | Diesel | SUV | Medium SUV | combustion | Small fleet | NaN | NaN | NaN | NaN | NaN | NaN |
| 8 | 1630 | 845562 | 32348357 | UK-C-845562 | Private Households | Private Households | susan fletcher | 2019-06-13 00:00:00 | ############################################################################################################################################################################################################################################################### | Operational | 00000000000005185732 | 364570060 | 1267425 | 482301484 | UK-1267425 | Mini | 2016-06-13 | MINI | 1.5 | BMW Group | Car | Small car | Petrol | 1.74 | 17168.00 | 0.00 | 0.00 | Full service Closed calculation | 1499 | 100 | 1670 | 1205 | 114 | 3 | 2 | 6 | 4000 | 168.37 | 0.00 | 0.00 | Mini | Mini | Unleaded | Sports | Sports | combustion | Private Households | NaN | NaN | NaN | NaN | NaN | NaN |
| 9 | 1631 | 845562 | 32348357 | UK-C-845562 | Private Households | Private Households | susan fletcher | 2016-06-13 00:00:00 | 2019-06-12 00:00:00 | Ended | 00000000000005185732 | 273174675 | 1061966 | 417380645 | UK-1061966 | Mini | 2016-06-13 | MINI | 1.5 | BMW Group | Car | Small car | Petrol | 1.74 | 17168.00 | 0.00 | 0.00 | Full service Closed calculation | 1499 | 100 | 1670 | 1205 | 114 | 3 | 2 | 36 | 24000 | 160.00 | 0.00 | 2088.33 | Mini | Mini | Unleaded | Sports | Sports | combustion | Private Households | NaN | NaN | NaN | NaN | NaN | NaN |
Last rows
| srno | customer_number | customer_id | customer_local_key | branch_desc_cons | business_classification_desc | driver_name | start_date_leasecontract | end_date_leasecontract | leasecontract_status_cons | customer_driver_id | lease_contract_id | leasecontract_number | vehicle_id | vehicle_local_key | make_cons | registration_date | model_cons | model_type_desc | manufacturer_group | vehicle_type_cons | vehicle_segment_desc | primary_fuel_type_cons | fuel_consump_manufacturer | cat_price_euro | cat_price_options_euro | cat_price_accessories_euro | product_name_cons | engine_capacity | engine_power | gross_weight | tare_weight | co2_level_combined | number_of_cylinders | number_of_doors | contract_duration | contract_mileage | monthly_lease_installment | supplier_discount_perc | discount_to_customer | enriched_make | enriched_model | enriched_primary_fuel_type | segment_global | segment_regional | new_powertrain_type | Customer_Segment | Unnamed: 47 | Unnamed: 48 | Unnamed: 49 | Unnamed: 50 | Unnamed: 51 | Unnamed: 52 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 83851 | 6198 | 34575 | 24084075 | UK-C-34575 | Not consolidated | Governments | ** 20T ***MARTIN SANG | 2013-07-23 00:00:00 | 2018-08-29 00:00:00 | Ended | N6850U | 159172066 | 9805187 | 337040763 | UK-9805187 | Opel | 2013-06-12 | MOVANO | D125 L2H1 D/S | GM | Van | Commercial van | Diesel | 0.0 | 28634.33 | 0.00 | 0.00 | Full service Closed calculation | 2298 | 92 | 3500 | 2187 | 0 | 4 | 0 | 60 | 100000 | 331.61 | 0.0 | 0.00 | Opel | Movano | Diesel | Medium Commercial | Medium Commercial | combustion | Governments | NaN | NaN | NaN | NaN | NaN | NaN |
| 83852 | 6199 | 21799 | 23494184 | UK-C-21799 | Special Trade Contractors | Small fleet | * UNSPECIFIED | 2010-10-16 00:00:00 | 2011-04-19 00:00:00 | Ended | UNSPEC | 133551762 | 8809202 | 244723074 | UK-8809202 | Audi | 2006-10-16 | A3 | 2.0D140 S-LINE | VAG | Car | Compact car | Diesel | 0.0 | 20712.54 | 0.00 | 0.00 | Full service Closed calculation | 1968 | 103 | 1940 | 1380 | 146 | 4 | 5 | 6 | 5000 | 248.59 | 0.0 | 0.00 | Audi | A3 | Diesel | Lower Medium | C2 - lower medium + | combustion | Small fleet | NaN | NaN | NaN | NaN | NaN | NaN |
| 83853 | 6200 | 29738 | 23495987 | UK-C-29738 | Private Households | Private Households | * UNSPEC | 2011-06-23 00:00:00 | 2012-06-21 00:00:00 | Ended | UNSPEC | 133716205 | 9246031 | 244772840 | UK-9246031 | Fiat | 2008-03-27 | GRANDE PUNTO | 1.2 8v ACTIVE | Fiat Group | Car | Small car | Petrol | 0.0 | 7565.65 | 0.00 | 0.00 | Full service Closed calculation | 1242 | 48 | 1575 | 1015 | 139 | 4 | 3 | 12 | 12000 | 155.37 | 0.0 | 0.00 | Fiat | Punto | Premium Unleaded | Small | B - small | combustion | Private Households | NaN | NaN | NaN | NaN | NaN | NaN |
| 83854 | 6201 | 909458 | 23605658 | UK-C-909458 | Not consolidated | Governments | * CARPOOL 1 | 2011-06-01 00:00:00 | 2017-06-06 00:00:00 | Ended | 1 | 133717554 | 9245168 | 244772772 | UK-9245168 | Mercedes Benz | 2005-11-23 | SPRINTER | 311CDi VAN 3.5T | Daimler AG | Van | Commercial van | Diesel | 0.0 | 22163.67 | 0.00 | 0.00 | Full service Closed calculation | 2148 | 80 | 3500 | 1945 | 0 | 4 | 5 | 12 | 20000 | 141.60 | 0.0 | 0.00 | Mercedes | Sprinter | Diesel | Medium Commercial | Medium Commercial | combustion | Governments | NaN | NaN | NaN | NaN | NaN | NaN |
| 83855 | 6202 | 909458 | 23605658 | UK-C-909458 | Not consolidated | Governments | * CARPOOL 1 | 2011-06-01 00:00:00 | 2011-09-19 00:00:00 | Ended | 1 | 133717550 | 9245118 | 244773243 | UK-9245118 | Mercedes Benz | 2005-11-23 | SPRINTER | 311CDi VAN 3.5T | Daimler AG | Van | Commercial van | Diesel | 0.0 | 22163.67 | 0.00 | 0.00 | Full service Closed calculation | 2148 | 80 | 3500 | 1945 | 0 | 4 | 5 | 12 | 20000 | 141.60 | 0.0 | 0.00 | Mercedes | Sprinter | Diesel | Medium Commercial | Medium Commercial | combustion | Governments | NaN | NaN | NaN | NaN | NaN | NaN |
| 83856 | 6203 | 909458 | 23605658 | UK-C-909458 | Not consolidated | Governments | * CARPOOL 1 | 2011-06-01 00:00:00 | 2017-06-06 00:00:00 | Ended | 1 | 133717545 | 9245061 | 244772767 | UK-9245061 | Mercedes Benz | 2005-11-23 | SPRINTER | 311CDi VAN 3.5T | Daimler AG | Van | Commercial van | Diesel | 0.0 | 22163.67 | 0.00 | 0.00 | Full service Closed calculation | 2148 | 80 | 3500 | 1945 | 0 | 4 | 5 | 12 | 20000 | 141.60 | 0.0 | 0.00 | Mercedes | Sprinter | Diesel | Medium Commercial | Medium Commercial | combustion | Governments | NaN | NaN | NaN | NaN | NaN | NaN |
| 83857 | 6204 | 909458 | 23605658 | UK-C-909458 | Not consolidated | Governments | * CARPOOL 1 | 2011-06-01 00:00:00 | 2017-06-06 00:00:00 | Ended | 1 | 133717551 | 9245132 | 244773244 | UK-9245132 | Mercedes Benz | 2005-11-23 | SPRINTER | 311CDi VAN 3.5T | Daimler AG | Van | Commercial van | Diesel | 0.0 | 22163.67 | 0.00 | 0.00 | Full service Closed calculation | 2148 | 80 | 3500 | 1945 | 0 | 4 | 5 | 12 | 20000 | 141.60 | 0.0 | 0.00 | Mercedes | Sprinter | Diesel | Medium Commercial | Medium Commercial | combustion | Governments | NaN | NaN | NaN | NaN | NaN | NaN |
| 83858 | 6205 | 24324 | 23499666 | UK-C-24324 | Business Services | Corporate | (VAN) STEVE BLAKE | 2010-09-16 00:00:00 | 2016-03-01 00:00:00 | Ended | 100802 | 133540144 | 8573542 | 244647270 | UK-8573542 | Peugeot | 2010-09-16 | PARTNER | 1.6D90 850 S FP | PSA | Van | Car derived van | Diesel | 0.0 | 14303.26 | 0.00 | 1033.08 | Open Calculation | 1560 | 66 | 2180 | 1332 | 153 | 4 | 0 | 48 | 45416 | 254.92 | 10.5 | 4567.08 | Peugeot | Partner | Diesel | Car Derived Commercial | Car Derived Van | combustion | Corporate | NaN | NaN | NaN | NaN | NaN | NaN |
| 83859 | 6206 | 24324 | 23499666 | UK-C-24324 | Business Services | Corporate | (VAN) STEVE BLAKE | 2011-09-30 00:00:00 | 2015-12-01 00:00:00 | Ended | 100802 | 133726466 | 9394652 | 244787723 | UK-9394652 | Peugeot | 2011-09-30 | PARTNER | 1.6D92 850 S | PSA | Van | Car derived van | Diesel | 0.0 | 14470.03 | 0.00 | 2696.45 | Open Calculation | 1560 | 66 | 2170 | 1305 | 136 | 4 | 5 | 48 | 35560 | 255.99 | 11.0 | 4997.85 | Peugeot | Partner | Diesel | Car Derived Commercial | Car Derived Van | combustion | Corporate | NaN | NaN | NaN | NaN | NaN | NaN |
| 83860 | 6207 | 24324 | 23499666 | UK-C-24324 | Business Services | Corporate | (VAN) STEVE BLAKE | 2011-12-07 00:00:00 | 2016-03-16 00:00:00 | Ended | 100802 | 133717323 | 9243006 | 244733435 | UK-9243006 | Ford | 2011-12-05 | TRANSIT CONNECT | 1.8D90 200 | Ford Motor Co. | Van | Car derived van | Diesel | 0.0 | 15287.20 | 44.52 | 812.16 | Open Calculation | 1753 | 66 | 2040 | 1427 | 164 | 4 | 0 | 48 | 26080 | 245.05 | 11.0 | 4881.25 | Ford | Transit Connect | Diesel | Car Derived Commercial | Car Derived Van | combustion | Corporate | NaN | NaN | NaN | NaN | NaN | NaN |